View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave L[_3_] Dave L[_3_] is offline
external usenet poster
 
Posts: 1
Default Selective formula pasting

Hi

I'm very much a novice at VBA and have created a macro which includes a
formula to calculate a sales parameter. However as the number of rows in the
range will change month on month I need to alter the cell range that the
formula is pasted into. Is this possible?