Working with a Range Variable...syntax

Question

I have the following code:

Set rFinder = wkEnrollment.Range("EnrollmentIDs")  
With Range(rFinder)
    Set LastCell = .Cells(.Cells.Count)
End With

It errors when I do my With Range(rFinder) line. rFinder is dim'd as a Range. The error is:

Method 'Range' of object '_Global' failed

I am not sure of the syntax on this?

mechanical_meat · Accepted Answer · 2013-01-18 22:03:45Z

1

Since rFinder is already a Range object you should simply use:

Set rFinder = wkEnrollment.Range("EnrollmentIDs")  
With rFinder
    Set LastCell = .Cells(.Cells.Count)
End With

answered Jan 18, 2013 at 22:03

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

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

1 Answer 1