Skip/Do not run Macro on the cell if empty/blank

**Talazem** · 11-01-2012, 09:47 AM

Hello,

I have macro; but I get an error when some of the cells are empty. I need to add coding so that it skips if there is no data in the cells or not to run the macro on empty cells.

Please Login or Register  to view this content.

Can anyone kindly advise. Thank you for your help

**TMS** · 11-01-2012, 09:59 AM

Either use IF to test the cell(s) before issuing the GoalSeek function, or use "On Error Resume Next" before you start and "On Error GoTo 0" at the end of your code.

Regards, TMS

**Talazem** · 11-01-2012, 04:33 PM

Thanks a bunch. It worked wonderfully.

**TMS** · 11-01-2012, 06:25 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save