Error in macro when no data is available

[PChav]

This macro I currenly use takes data from each month of the year so far (data is updated on a daily basis) and manipulates it on a different sheet. I have writen the macro for the entire year, but since there is no data yet for October, I get an error when it tries to take that data out. The error occurs on the Columns("C:C").SpecialCells line. There, I have selected the Go To option, then special, then selected formulas and text. Is there any way that I could write some code so that if there is no data to select, it stops or goes on to do something else? I have looked into loops, but am not sure it would be best for this situation as there is much more to this code than shown. I hope I have done a decent job explaining my situation, as I am still slowly learning how to write macros. Any help would be greatly appreciated. Thanks.

Please Login or Register  to view this content.

[VBA Noob]

Maybe something like

Not fully tested

Please Login or Register  to view this content.

VBA Noob

[mudraker]

Closing thread as PChav has posted a new thread with a better discription of his/her problem