CODEWITHSUNDEEP
vbaexcel
Grompy
Grompy

Reputation: 35

Defining an Excel Range

I'm trying to define 2 ranges in 2 seperate workbooks and manipulate the data. However when I define the range below:

SAPBook = ActiveWorkbook.Name
SAPSheet = ActiveSheet.Name

SAPRange = Workbooks(SAPBook).Worksheets(SAPSheet).Range("A:A")

SAPRange.Select

The range is nothing and nothing gets selected. So I thought maybe I wasn't being explicit enough in my select call, but the below will select nothing as well.

Workbooks(SAPBook).Worksheets(SAPSheet).Range(SAPRange).Select

If I don't define my range and use the following everything works just fine. 

Workbooks(SAPBook).Worksheets(SAPSheet).Range("A:A").Select

Why can't I define my range and select the Range? What am I missing here? I'm sure it's something easy..

Upvotes: 2

Views: 174

Answers (1)

tigeravatar
tigeravatar

Reputation: 26640

You need to use the Set keyword:

Set SAPRange = Workbooks(SAPBook).Worksheets(SAPSheet).Range("A:A")

Upvotes: 3

Related Questions