use variable to make things easy

[Gregfox]

I have the following code courtesy of Michael M. Is there away I could put a variable at the top of the code to change the year(withdraw_2018) to be, withdraw_2019, withdraw_2020etc. as the years change rather than hunting through the code looking for the year?
I tried;

Dim X as string
X = withdraw_2018

and then used X inthe following code in place of withdraw_2018, but it failed.

WithDraw = Range("withDraw_2018").Address(0, 0)
With Sheets("Fisher").Range("I2")
   .Formula ="=SUM(I3:" & WithDraw & ")"
   .NumberFormat ="$#,##0_);[Red]($#,##0)"
End With

 

[RoryA]

You'd need to use this:

WithDraw = Range(X).Address(0, 0)

 

[Norie]

Try this.

Dim X As String

    X = "Withdraw_2018"

    With Sheets("Fisher").Range("I2")
       .Formula ="=SUM(I3:" & X & ")"
       .NumberFormat ="$#,##0_);[Red]($#,##0)"
    End With

 

[Gregfox]

Thank you.