View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Need help to have macro populate a column with formula to end ofcolumn.

how does the program decide where the end of the column is?
susan

On Jan 22, 2:17*pm, S Himmelrich wrote:
My formula that should populate column K is: =SUM(J1/MACRO!G11), which
takes the value in the same row (column J) and divides into a
refereced cell, which will stay the same always. *The macro should
evaluate until the end of the column.