Macro - I thing it has something to do with end of range

[brandc]

Count down a column as previous request is working great thanks

What do I do when I get to the end of the numbers and it is a blank
my macro errors. (As if it wouldn't!)

I have looked up all the End of Range - previous chats - but don't
see how I can make it work. (I assume that this would be the go)

Please advise

Regards
CB

 

[Guest]

add this to your macro:

If cell.value="" then
exit sub
end if
Some user info may be found at:
http://au.geocities.com/excelmarksway

regards
Mark E. Philpot

 

[support]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin