select vs. activate

S

SP

What's the difference between select and activate ?

Ex. sheets("abc").select and sheets("abc").activate

Thanks
Steve
 
G

Guest

Generally, many folks use them interchangeably. the difference is you can
select several sheets, but only one is the activesheet. same thing for
ranges.
 
O

OJ

try this...

Sub selectem()
ThisWorkbook.Sheets(Array(1, 2, 3)).Select
End Sub

Then try this...

Sub selectem()
ThisWorkbook.Sheets(Array(1, 2, 3)).Activate
End Sub

One difference....;o)

OJ
 
S

SP

thank you

JMB said:
Generally, many folks use them interchangeably. the difference is you can
select several sheets, but only one is the activesheet. same thing for
ranges.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change to active sheet on macro? 2
create sheet based on value in string 2
Toggle between True and False confuses me 3
i = row number of last occurance of duplicate string Column A 4
Run macro from active workbook whose name keeps changing 20
activate unknown workbook 5
ActiveCell on inactive sheet 8
VBA Copying/Pasting problem when data is filtered 1

Top