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