Anyone any good with Excel Macros/VBA code?

[CupDude]

Wee brainteaser for y'all..

I've written a basic a macro that selects formula cells that contain values.

It works fine if there are these type of cells found, but if there arent, the macro stops & reverts to the VBA editor.

Is there code I can insert which basically says if no cells found then stop the macro running?

 

[RSi Dave]

could use an if statement.

e.g.

if range(A1:A1) = "forumla" then
'enter formula code here
else
end