Thread: worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default worksheets

I found this in the help file:
Worksheets("Sheet1").Activate

Do I need to use this .activate command and then this:

with worksheets("sheet1")
.range("A1") = "foo"
.cells(2,1) = .range("A1")
end with

....or can I just use this with command to activate whichever sheet I'm
refering to?
thanks.