View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pam[_4_] Pam[_4_] is offline
external usenet poster
 
Posts: 1
Default Macros - Range Selection

I have a spreadsheet with data in columns 1 thru 5. In
column 6, I want the macro to add a value. The number of
rows in the spreadsheet varies. How do I select the same
number of rows in column 6 as are non-blank in columns 1-
5?