Need help on leaving blank cell on error and continuing macro

[WinningKing]

Hey all,

I keep getting an error Run-time error '5' at this step

Please Login or Register  to view this content.

I know the reason why I'm getting an error.
However, I want to know if there is any way to make it such that if there is an error, resume next or leave an empty space?

I tried to add in the if error resume next, but it doesn't work.


Below is my original code

Please Login or Register  to view this content.

[MarvinP]

Hi,

Look at this site for Error Handling.
http://www.cpearson.com/excel/ErrorHandling.htm
On Error Resume Next
should go above the possible problem. Is that what you did?

[WinningKing]

I inserted the On Error Resume Next in the 2nd last line, but I still get an error when the keywords are missing from the txt file.