Variable with Offset function to create a range

Question

I am trying to use a variable alongside the offset function to create a range which I can then utilise.

I have the below code however this errors on the last line.

Dim rng As Range
Dim targetrow As Range
targetrow = ActiveSheet.Range("Total").Offset(-2, 0).Row
rng = Range(Cells((targetrow), 7), Cells(10, 7))

Any help would be much appreciated

Thanks

Rory · Accepted Answer · 2015-10-19 14:34:31Z

1

You need to use Set with object variables:

Set rng = Range(Cells((targetrow), 7), Cells(10, 7))

answered Oct 19, 2015 at 14:34

Rory

34.2k5 gold badges40 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

And you need to declare targetrow as Long instead of Range