Brock_Hardchest
New Member
- Joined
- Feb 23, 2018
- Messages
- 27
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!
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!
VBA Code:
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