why doesn't this range work?

[aiden1983]

Ok So my script is calling a few workbooks and it can select one cell but when I do this:

Workbooks(Pay).Sheets("Input").Range(Cells(2, 2), Cells(20, 2)).Select

it doesn't work anymore.

If I do this:

Workbooks(Pay).Sheets("Input").Cells(2, 2).Select

it works fine, but I need the whole range.

Any ideas?

 

[Richard Schollar]

You need to fully qwualify the Cells() objects (otherwise they refer to the Activesheet which may not be the same as the Input sheet. Hence, write it like:

With Workbooks(Pay).Sheets("Input")
  .Range(.Cells(2, 2), .Cells(20, 2)).Select
End With

and note the period (.) before each Cells().

 

[aiden1983]

That works perfect. I am not familiar with the with statements, but it looks like I will have to learn.

 

[Richard Schollar]

The with is essentially providing a shortcut way of writing the following:

Workbooks(Pay).Sheets("Input").Range(Workbooks(Pay).Sheets("Input").Cells(2, 2), Workbooks(Pay).Sheets("Input").Cells(20, 2)).Select