View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
uberathlete[_7_] uberathlete[_7_] is offline
external usenet poster
 
Posts: 1
Default Autofill until blank cell is reached


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
+-------------------------------------------------------------------

--
uberathlet
-----------------------------------------------------------------------
uberathlete's Profile: http://www.excelforum.com/member.php...fo&userid=2838
View this thread: http://www.excelforum.com/showthread.php?threadid=48221