Setting range in an inactive sheet

[MuskyMan]

Requesting help for this rookie! Having run-time error after the loop, can't seem to get the syntax or I'm missing something.

Thanks for the help..


Private Sub CommandButton1_Click()

For i = 1 To 110
Sheet2.Cells(i, 1) = i
Next i

Workbooks("PM").Worksheets("LastMnthPM").Range(Range(Cells(1, 1), Cells(i, 1))).Select

End Sub

 

[SkipVought]

Hi,

Please post VBA questions in Forum707.

You cannot SELECT an object on a sheet that is not active. Why do you want to SELECT? Please answer in your new thread in Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}