View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CINDY CINDY is offline
external usenet poster
 
Posts: 130
Default adding a formula in macro

I have a column of items I want to count. The length of the column changes
by spreadsheet. I would like the macro to start in the first blank cell and
move up one cell and count all items to row 1. How do I code this when the
originating cell address will change? thanks! cm