View Single Post
  #1   Report Post  
JN
 
Posts: n/a
Default Macro - formula for end of last row

Hi,

I want to set up a macro to have different formulas on the last row of the
worksheet. Each month, the amount of data is different. This is what the
macro to do:

two rows below the last row of the data, set up formulas in column E, L to
R. Each formula ties to data from the last row.

I tried to set up the macro using selection.end(xlsDown), somehow, I can't
make it to work. Please help. Thanx