Variables in a Range method

[Brock_Hardchest]

Hello,

I am trying to fill down a range of cells based off of the bottom row in two different worksheets. The .FillDown line of code errors and I am not sure why. Any help is appreciated. Thanks!

Sheets("sheet1").Activate
row = Cells(Rows.Count, 1).End(xlUp).row
Range("A3:V" & row).Copy
Sheets("All Data").Activate
row2 = Cells(Rows.Count, 1).End(xlUp).row
Debug.Print row; " "; row2
Range("A" & row2 + 1).PasteSpecial
Range("W" & row2 + 1).Value = monthend 'this is a date set in the macro
Range("W" & row2 + 1 & ":W" & row + row2).FillDown

 

[Fluff]

Change the Variable row to Row1 or something else, you should never use VBA keywords as variables.
here

row = Cells(Rows.Count, 1).End(xlUp).row

you have used row twice & it's two totally different things. How is VBA meant to understand what you mean.

 

[Brock_Hardchest]

Fantastic! If I was VBA I would be confused too!

 

[Fluff]

You're welcome & thanks for the feedback.