Thread: Range selection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 414
Default 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.