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