Help debugging macro

Hi,

I'm not very good at macros and I juggled some rows around in my spreadsheet which seems to have stopped the macro I had from working. Can someone help me bedug, I don't understand what's wrong with it?

DEBUG HELP.JPG

Please Login or Register  to view this content.

You don't have data after column 24 on row 5. In the cells up to that point, you have numbers (week start/end/whatever). After that, you just have buttons. I suspect that has something to do with it.

As AB33 has said, if there are no visible cells in the range, that's why you get the error. But I would suggest that you don't just want to ignore the error, you need to condition the rest of the code following on myRange not being Nothing.


Regards, TMS

You're welcome. Thanks for the rep.



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


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.