Run time error 438, object doesnt support this property or method

I'm having some issues with my macro that previously worked perfectly I have no idea what is going on when I run it to consolidate my sheets named A-Z it stops after G and gives me an error that Run time error 438, This doesn't occur on my practice sheet only on my main workbook and the error is with the LR = .Cells(.Rows.Count, 8).End(xlUp).Row

Please Login or Register  to view this content.

So basically this macro works on my practice sheet but when I apply it to my main sheet is hiccups and stops at Sheet G when consolidating sheets A-Z and gives me a runtime error - the error seems to be with this line LR = .Cells(.Rows.Count, 8).End(xlUp).Row not sure what's going on it was working yesterday on my main sheet but now it doesn't.

LR = .Cells(.Rows.Count, 8).End(xlUp).Row
----------^ remove the dot (there's not Sheets.Rows property.

LR = .Cells(Rows.Count, 7).End(xlUp).Row
So like that?

That's it.

sh.rows returned valid number of rows for me.

I would think the problem lies in the variation of data/structure in the workbook. A simple test of your code on dummy data works.
You loop through Sheets which can include non worksheet objects, such as chart sheets which indeed do not have .Rows collection.

maybe should change

Please Login or Register  to view this content.

Still having issues with this one, It works when all the data is removed but for some reason something goes wrong on my active book and its still stopping after sheet G All sheets are exactly the same format so im still unsure what's going on.

So here are the 2 files, the VBA one contains my macro and I call it up in my Main sheet to consolidate the sheets. unfortunately it no longer works in the main sheet. Can someone take a crack at it and tell me what went wrong?

Your buggy file contains a chart sheet, which has not cells/rows/columns etc.

loop through the worksheet rather than sheet collection

Please Login or Register  to view this content.

that's weird, It shouldn't have any chart sheets lol. how would I delete that?

right click a sheet tab an pick Unhide.

your a life saver!, dunno who added that in there lol