PDA

View Full Version : select issue



nedy_03
10-17-2007, 09:58 AM
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

lucas
10-17-2007, 10:21 AM
see if this example gives you any help Nedy...see attached.

Norie
10-17-2007, 10:38 AM
Nedy

Perhaps the answer given in your cross-post http://www.mrexcel.com/board2/viewtopic.php?t=297311 might help. :roll:

lucas
10-17-2007, 10:54 AM
Nedy,
cross posting will cause folks to not want to help you....please read our faq and this (http://www.excelguru.ca/node/7) for an explaination..