View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
McKCollins McKCollins is offline
external usenet poster
 
Posts: 2
Default loop macros until reach blank in adjacent column

I have two columns, A & B. Column A contains data, column B contains a
(VLOOKUP) formulae referencing column A. I want the VLOOKUP formulae to loop
down column B until it reaches a blank in column A.