Runtime Error 1004 Application-defined or Object-defined Error while selecting Range

Hi,

I've decided to try going another route from an earlier problem I had which I wasn't able to fix. What I'm trying to do now is clear the contents of all rows below the first blank cell in column A for all open workbooks and then do a little formatting. Here is the full code:

Please Login or Register  to view this content.

I get the aforementioned error on the line

Please Login or Register  to view this content.

If I remove

Please Login or Register  to view this content.

and have two workbooks open at the same time, it just runs the macro on the first workbook twice and doesn't touch the second workbook.

If I remove

Please Login or Register  to view this content.

from the code and leave everything else the same then it properly bolds and underlines the correct cells in each sheet and works perfectly. So I know the problem must be somewhere in the above set of code (or maybe how it interacts with the Workbooks Collection object.) Also, I am running this code from PERSONAL.xlsb so I'm not sure if that makes a difference when referencing workbooks.

Any ideas?

Hi, Norie!

That code bolded and underlined the cells in both workbooks but didn't clear any contents.

Same thing