Autofill until blank cell is reached

[uberathlete]

Hi all! I've got Sheet 1 (see attached). Let's say I've got a formul
(assume a VLOOKUP formula) in B2 and I want to autofill down to th
other cells in the B column until a blank column is reached in the *A
column. Does anyone know how I can make a macro for this? Any hel
would be greatly appreciated. Thanks

+-------------------------------------------------------------------
|Filename: Sheet1.JPG
|Download: http://www.excelforum.com/attachment.php?postid=3993
+-------------------------------------------------------------------

 

[Dave Peterson]

You have answers at the other post in .misc.

Hi all! I've got Sheet 1 (see attached). Let's say I've got a formula
(assume a VLOOKUP formula) in B2 and I want to autofill down to the
other cells in the B column until a blank column is reached in the *A*
column. Does anyone know how I can make a macro for this? Any help
would be greatly appreciated. Thanks!

+-------------------------------------------------------------------+
|Filename: Sheet1.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3993 |
+-------------------------------------------------------------------+

 

[uberathlete]

Yikes! I tried the code but it didn't work. It fills up the B column
alright, but it continues for every cell in the B column. I was hoping
the autofill would stop when there is no value in the A column. Any
thoughts on this?

 

[Dave Peterson]

I thought your reply in .misc meant that it worked for you.

You may want to post what you tried.

It's a pain to check all the locations when you multipost, huh?