Thread: Activate Sheet Best Practice (Y/N?) when xFer data between sheets?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Activate Sheet Best Practice (Y/N?) when xFer data between sheets?

A waste

--
Don Guillett
SalesAid Software

wrote in message
...
2007 (2003 compatability)


When data is being transferred to/from worksheets in the same wb, is it a
best practice or a waste
of time to actually issue wks1.activate then wks2.activate then
wks1.activate, etc?

The actual transfers are being accomplished using:

wks1.activate <----- Is this smart or a waste?
With wks1
.Range("A1").value = wks2.Range("A11").value
.Range("A2").value = wks2.Range("A27").value
.Range("A3").value = wks2.Range("A42").value
.Range("A4").value = wks2.Range("A53").value
.Range("A5").value = wks2.Range("A78").value
End With

TIA EagleOne


Reply With QuoteReply With Quote