I have this formula that I use that works well for me. The only problem is I get this error if I only have one line and no other that need to be dragged down.
[CODE]Range("A1:D1").AutoFill Destination:=Range("A1:D" & Cells(Rows.Count, "H").End(xlUp).Row)CODE]
error.JPG
Thanks in advance!!!
What's the formula? What does the rest of the code look like? Can you post a sample workbook?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If H has data in only row 1, then there are no cells in H for the code to count and then drag down for the other columns.. Add some data to some other rows in column H, then run it.
If you have data down H, it should drag down the other columns as desired. Worked for me.
I tested that line of code
everything is ok but the error will appear if there are no data in Column H
Please Login or Register to view this content.
If you must use AutoFill, maybe this:
Please Login or Register to view this content.
Regards, TMS
Last edited by TMS; 11-12-2014 at 08:13 PM.
I settled with the following but TMS is correct there must be an if then
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks