1st post, Hi everyone!
macro copies a cell with formula '=-H4' to the row below, so the copied cell is '=-H5' as you would expect
but I want the cell formula to be '=-G4'
How can I do this?
1st post, Hi everyone!
macro copies a cell with formula '=-H4' to the row below, so the copied cell is '=-H5' as you would expect
but I want the cell formula to be '=-G4'
How can I do this?
Last edited by FZ1; 01-15-2018 at 05:10 PM.
Assuming the cell wth the formula is on row 4 then
Formula:Please Login or Register to view this content.
otherwise if it's on another row change the reference to '4'
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
I used something else and got it to work, thanks for the help!
For our edification, what did you use?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks