Range selection
Can anyone help with this Ver 8.0 Excel problem?
When running this code it fails at the Select line even though "Bingo" is a
valid Worksheet in the Workbook :-
Dim sht As WorkSheet
Set sht = Worksheets("Bingo")
With sht
.Range(Cells(1, 2), Cells(1, 2)).Select
End With
Does it need ActiveWorkbook in front of Worksheets?
Thanks.
|