Hi,
I have a worksheet which changes the number of rows each day
I have the above but i dont want to referance E3 as this cell may move up or down depending on the volume of data i have.
ActiveCell.AutoFill Destination:=Range("E3:E" & Range("D" & Rows.Count).End(xlUp).Row)
I basically want to use the ActiveCell and to auto populate based against column D.
Kind Regards
Chris
You may try:
ActiveCell.AutoFill Destination:=Range(Activecell, Cells(Range("D" & Rows.Count).End(xlUp).Row, Activecell.Column))
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Another?
ActiveCell.AutoFill Destination:=Range("E" & activecell.row & ":E" & Range("D" & Rows.Count).End(xlUp).Row)
Excellent works a charm thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks