Evening All,
I am looking to Find a Value in a list dosome deleting of relevant data in the same row and move onto the next occurrence of the same Value in the list. I seem to sorted that out but I have encountered an error code after the last Value:
Runtime Error'91'
Object Variable or With block variable not set
The code line on Debug is:
Cells.FindNext(After:=ActiveCell).Activate
I would ideally like to operate an IF statement to 'break out' if the FindNext 'fails' but it seems to be eluding me at the moment.
Any help appreciated.
Cheers
S
I am looking to Find a Value in a list dosome deleting of relevant data in the same row and move onto the next occurrence of the same Value in the list. I seem to sorted that out but I have encountered an error code after the last Value:
Runtime Error'91'
Object Variable or With block variable not set
The code line on Debug is:
Cells.FindNext(After:=ActiveCell).Activate
I would ideally like to operate an IF statement to 'break out' if the FindNext 'fails' but it seems to be eluding me at the moment.
Any help appreciated.
Cheers
S