Hi All,
I am new to this Excel Macro world,
I have made the macro for Copy and paste value substract.
but Every time I have to Edit the Range to be copied and Range to be pasted.
I want to make it refer to a particular worksheet so that I do not have to edit Macro every time and make it Variable
I have tried multiple times but all did not work for referencing.
Below is the Macro I have written
Sub Jan_Macro()
Sheets("Financials").Select
Range("EV265:FV265").Select -----> ( I want range EV265:FV265 should come from different worksheet called "Update Sheet" and Cell "C2") where I have written EV265:FV265)
Selection.Copy
Sheets("Revenue").Select
Range("EV711:FG711").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlSubtract, _
SkipBlanks:=False, Transpose:=False
Sheets("Financials").Select
Range("EV266:FG266").Select
Selection.Copy
Sheets("Financials").Select
Range("EV189:FG189").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlSubtract, _
SkipBlanks:=False, Transpose:=False
End Sub
I just need way and it will also help me in future projects I also tried searching on google but unable to get perfect solution.
Thanks in advance
Atishay
Bookmarks