Autofill until blank cell is reached

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!

You have answers at the other post in .misc.

uberathlete wrote:
>
> 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
> ------------------------------------------------------------------------
> uberathlete's Profile: http://www.excelforum.com/member.php...o&userid=28388
> View this thread: http://www.excelforum.com/showthread...hreadid=482217

--

Dave Peterson

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?

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?

uberathlete wrote:
>
> 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?
>
> --
> uberathlete
> ------------------------------------------------------------------------
> uberathlete's Profile: http://www.excelforum.com/member.php...o&userid=28388
> View this thread: http://www.excelforum.com/showthread...hreadid=482217

--

Dave Peterson