Activate Sheet Best Practice (Y/N?) when xFer data between sheets?
 

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

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

Activate Sheet Best Practice (Y/N?) when xFer data between sheets?
 

Thanks Don,

Yep! I figured that - But - I was concerned that I may be missing something.

"Don Guillett" wrote:


A waste