sheetspread
Well-known Member
- Joined
- Sep 19, 2005
- Messages
- 5,160
Lets say I want to highlight any cell or cells and multiply them all by the value in cell I7. Paste special multiply will leave me with the correct number but not the formula.
I7= 1.05
Say A4 = 100
Showing 105 is good but in the cell formula I'd like =100*1.05 to appear
Is there a VBA code or other technique that works?
I7= 1.05
Say A4 = 100
Showing 105 is good but in the cell formula I'd like =100*1.05 to appear
Is there a VBA code or other technique that works?