Greetings - I am using the following code in a workbook to quickly autofill the data on the last row down to the next row....
The workbook has 67 worksheets in it (I use the above snippet for each sheet) and the macro runs perfectly on every sheet - except for 1 sheet! I have looked at this sheet intensively for anything that might be different from the others and I can find nothing that is different. There is not any coding on the worksheet itself, there are nothing in one of the cells somewhere else on the sheet, I do not get any error messages, the debugger cycles through fine - just nothing happens when the macro runs - I am stumped. Does anyone have an idea of what I should check for?
VBA Code:
Dim LR As Long
Sheets("Fume Scrubbers").Activate
LR = Range("A" & Rows.Count).End(xlUp).Row
Range("A" & LR).Resize(, 21).AutoFill Destination:=Range("A" & LR).Resize(2, 21)The workbook has 67 worksheets in it (I use the above snippet for each sheet) and the macro runs perfectly on every sheet - except for 1 sheet! I have looked at this sheet intensively for anything that might be different from the others and I can find nothing that is different. There is not any coding on the worksheet itself, there are nothing in one of the cells somewhere else on the sheet, I do not get any error messages, the debugger cycles through fine - just nothing happens when the macro runs - I am stumped. Does anyone have an idea of what I should check for?
Scratching my head again because there are no gaps in this column, there is a value in every cell... cycling the code keeps sending it down to the next line 533, 534, 535 - overwriting what is already there.
