Is There A Way To Subtract From VBA Range?

[aedctalk]

For the below code.. i'm wanting to do something like RangeJ40-8

Is that possible at all? how would i put that in?

If tried doing L40 as J40-8 and then putting L40 in here.. but that doesnt work.. So is there an alternative way? like withinin this vba?

Thanks so much!!

       If Not Intersect(Target, Range("J40")) Is Nothing Then
     Application.Run "BOWSER.xls!Unprotect"
        Call hideColumns2
        Application.Run "BOWSER.xls!Protect"
    End If

 

[Jonmo1]

What do you mean J40 - 8?

do you mean J32?

Or if J32's value is 100, then 92?

If you mean J40-8 is J32, use Offset

Range("J40").Offset(-8,0)

 

[aedctalk]

Hello. No i meant the other one

The value of J32 - 8 is that one possible?


Thank you!!