End If without Block If error

[Hammer_757]

To try and trap a separate error, I added and if, then else. However I keep getting "Compile Error: End If without Block If error" the "if" and "end if" count seems right to me. what am I missing?

Please Login or Register  to view this content.

The part I changed was:

Please Login or Register  to view this content.

prior to trying to build the error trap it was simply:

Please Login or Register  to view this content.

which did not return the End If without Block If error (but has a separate issue)
Thanks
Robert

[TMS]

ISERROR is a worksheet function and you can't use it, as you have, in VBA.

You'd need to use "On Error Resume Next" and test the Err.Number for a non-zero value. Then use "On Error Goto 0" to switch off the error trapping.

Regards, TMS

[Hammer_757]

TMS, I'm sorry I did not thank you right away. Thanks for correcting my usage if the ISERROR and pointing me off in the right direction. With the error trap fixed I still haven't fixed the original problem but Ill cover that in a separate post.
Thanks again for helping and responding to my post so quickly..
Robert

[AB33]

If you have indented your ifs, you could have easily spotted the error.

Please Login or Register  to view this content.