Thread: [Solved] Macro not Performing Formula Update as Expected
View Single Post
 
Old 06-25-2014, 11:41 AM
tandchas tandchas is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: May 2014
Posts: 7
tandchas is on a distinguished road
Default
Charlesdh,

I appreciate your reply but that portion of the code is supposed to paste the value only; not the formula. The portion of the code which I want to copy the formula is:

Rows("17:17").Select
Selection.Copy
Rows("17:17").Select
Selection.Insert Shift:=xlDown

The formual in cell J17 currently goes to row 89. When the macro runs, it still only goes to row 89 but I would like it to go to row 90 since it has added a row.
Reply With Quote