Thread: how to select cells from a non active worksheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
  
Posts: 735
Default how to select cells from a non active worksheet
If the non-active sheet is in the active workbook you can use.....

Sheets("Sheet1").Columns("A:A").Select

If it is in another workbook then use....

Workbooks("NonActive.xls").Sheets("Sheet1").Column s("A:A").Select
--

Regards,
Nigel




"Mekinnik" wrote in message
...
I am trying to select all the cells from column 'A' of the non-active
worksheet


Reply With QuoteReply With Quote