Jim Doornek
Board Regular
- Joined
- May 23, 2008
- Messages
- 52
Fluff
Per your request, I am submitting this request in a new thread.
For each of the individual worksheets being analyzed in the array, I'd like to get the total column count.
I added a line of code (lcolumn) to the "One week only" macro, that I thought would do this. However, the code is returning the column count in "Master" worksheet and not the columns in the individual array(i) for the worksheet being analyzed.
Here is where I added the line.
For i = 0 To UBound(myArr) Set myRng = Nothing
With Sheets(myArr(i))
lcolumn = Cells(1, Columns.Count).End(xlToLeft).Column
Here is a link to the entire workbook:
https://www.dropbox.com/s/5h8f56pcem...uler.xlsm?dl=0
Per your request, I am submitting this request in a new thread.
For each of the individual worksheets being analyzed in the array, I'd like to get the total column count.
I added a line of code (lcolumn) to the "One week only" macro, that I thought would do this. However, the code is returning the column count in "Master" worksheet and not the columns in the individual array(i) for the worksheet being analyzed.
Here is where I added the line.
For i = 0 To UBound(myArr) Set myRng = Nothing
With Sheets(myArr(i))
lcolumn = Cells(1, Columns.Count).End(xlToLeft).Column
Here is a link to the entire workbook:
https://www.dropbox.com/s/5h8f56pcem...uler.xlsm?dl=0