Thread: [Solved] Paste value of formula
View Single Post
 
Old 09-02-2021, 12:32 AM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Paste value of formula
Hi. I would like to perform the following repetitive task through macro.
Formula in H1: =CONCATENATE(B2,": ",C2)
I would need a macro that pastes the value of H1 to B2, then delete C2.
When I change the cell references from B2 to B7 and C2 to C7, the macro pastes the result in B7, then delete the value in C7.
I tried recording the steps but the range was stuck at B2 and C2.
Thank you.
Attached Files
File Type: xlsx Copy value of formula.xlsx (9.0 KB, 11 views)
Reply With Quote