Please solve the Error : Expected List separator..

**ANUARORA** · 11-23-2014, 09:47 AM

Hi,

I am getting an compile error expected List separator in the below line:

ColumnLetter = Mid(rCell, InStr(rCell , “$") + 1, InStr(2, rCell, “$”) – 2)

I am novice to excel.

Please can anyone help on this one.

Regards

**pjwhitfield** · 11-23-2014, 09:51 AM

ColumnLetter = Mid(rCell, InStr(1,rCell , “$") + 1, InStr(2, rCell, “$”) – 2)

you're missing the start position from 1st Instr

**ANUARORA** · 11-23-2014, 09:55 AM

I tried this..but still the same error..it is pointing error on somewhere $ sign..

**ANUARORA** · 11-23-2014, 10:05 AM

It worked...thanks

Please solve the Error : Expected List separator..

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Please solve the Error : Expected List separator..

Re: Please solve the Error : Expected List separator..

Re: Please solve the Error : Expected List separator..

Re: Please solve the Error : Expected List separator..

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Function Error: Compile error: Expected: list separator or )

[SOLVED] VBA custom function, Expected List Separator or )

Complie Error: Expected: list separator or (

[SOLVED] Continue code on next line: Compile Error: expected list separator or )

compile error – expected : list separator or )

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions