Hello,
I've recorded a macro that at a certain point use this selection sintax:
Range("H2").Select
Selection.AutoFill Destination:=Range("H2:H20")
I would need it to run the autofill until it find a blank value on column G. Can u help me on that? ..
Thx,
Nedy
see if this example gives you any help Nedy...see attached.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Nedy
Perhaps the answer given in your cross-post http://www.mrexcel.com/board2/viewtopic.php?t=297311 might help.
Nedy,
cross posting will cause folks to not want to help you....please read our faq and this for an explaination..
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
