select vs. activate

  • Thread starter Thread starter SP
  • Start date Start date
S

SP

What's the difference between select and activate ?

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

Thanks
Steve
 
Generally, many folks use them interchangeably. the difference is you can
select several sheets, but only one is the activesheet. same thing for
ranges.
 
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
 
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
Toggle between True and False confuses me 3
i = row number of last occurance of duplicate string Column A 4
create sheet based on value in string 2
Run macro from active workbook whose name keeps changing 20
VBA Copying/Pasting problem when data is filtered 1
I want to take select cells from other rows (2 and 3) and combinethem with row 1 1
activate unknown workbook 5

Back
Top