Thread: store formula in macro then paste it when macro runs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nina Nina is offline
external usenet poster
  
Posts: 22
Default store formula in macro then paste it when macro runs
I download a file every month and I need to format it adding columns,
deleting rows, etc - also I need to add some formulas to the file so that the
data is formatted according to my specifications and to be used in another
model.

The formula is to be pasted on cell B3 ... and the formula is
=RIGHT(LEFT(A3,16),3).

Thanks


Reply With QuoteReply With Quote