Code to calculate dates from multiple worksheets and consolidate to master sheet

[Jim Doornek]

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

 

[Fluff]

You've forgotten the . in front of Cells, it should be

lcolumn = .Cells(1, Columns.Count).End(xlToLeft).Column

 

[Jim Doornek]

Thanks again. Sorry I missed something that simple. I'm still learning.

 

[Fluff]

It happens to us all