Counter for my GetSheets vba

[beezie]

I have been trying to get a counter to populate column "L" in the active sheet for each workbook that is brought in using my GetSheets code (shown below). I need it to count when the counter is >0. The purpose of this is to use the results as a variable to drive another code to add in blank rows and paste certain cells from the other worksheets that are brought in. There is something I am missing as I have done this in the past with a counter but for some reason cant get it to work. Thank you!

Please Login or Register  to view this content.

[Leith Ross]

Hello beezie,

Welcome to the Forum!

First, you need to have a global variable that holds the count of the worksheets. A global variable can be accessed by any VBA routine.

Second, you need to increment this variable inside your macro.

Here is the revised code. This has to be in a VBA Module to work correctly.

Please Login or Register  to view this content.