Compile Error - If, Then, Else, End IF Process

[R_S_6]

Hi All,

A very simple one here I'm sure but I am getting this error every time I try and use an If function in VBA. I'd like to know the fundamental error of my ways!
The Code is:

Please Login or Register  to view this content.

sPath, FName 2 and sPathFName2 are variables. sPath is the file path and FName 2 is the file name.
Every time I try and run the above I get 'Compile Error: End If without Block If'

Any help appreciated as always.
Cheers,
Mark

[DonkeyOte]

In basic terms - because you have put the result if True on the same line as the test this is deemed "the end" - ie the Else does not apply to the If above, ie:

Please Login or Register  to view this content.

is the same as

Please Login or Register  to view this content.

in terms of modification

Please Login or Register  to view this content.

or replicate the : as you have on the Else - but don't let romperstomper see you !

[R_S_6]

Thank you very much! Very informative. That's something I wont forget now!
Cheers
Mark