|
|
|
|
#1
06-25-2014, 11:41 AM
|
|||
|
|||
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. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Performing filtering to tasks that occur during the next three months
|
jessy | Project | 1 | 05-30-2014 05:40 AM |
|
macro to update fields
|
PeaceDove | Word | 3 | 01-17-2012 02:45 PM |
| Compare and Update Macro | AaronMoss | Excel Programming | 2 | 05-06-2011 04:54 AM |
| Macro to update fields | rhatx | Word VBA | 0 | 03-02-2011 12:14 PM |
|
Excel 2011 not performing paste special correctly
|
mzimmers | Excel | 1 | 01-04-2011 06:17 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode