TAB index table?

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

In Excel is there and index table or an object that could be queried
for a specific Tab?
( Instead of looping on all the Tabs)
Thank's ahead.
 
Could you give an example of what you want to do?
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email






- Show quoted text -
Click to expand...

Yes!
If I want to use, let say a TMP Sheet for transfering data and erase
it after I finish with it.
 
If you want to start with a brand new sheet, then you could do something like:

Dim tmpWks as worksheet

set tmpwks = worksheets.add
'do a bunch of work
tmpwks.range("A1").value = "hi there"
tmpwks.usedrange.columns.autofit

'and delete it later
application.displayalerts = false
tmpwks.delete
application.displayalerts = true
 
In Excel is there and index table or an object that could be queried
for a specific Tab?
( Instead of looping on all the Tabs)
Thank's ahead.
Click to expand...

Hi Bobby,
Excel has not such a function, you have to built it by VBA - like Dave
suggested.
But have a look at free ASAP Utilities - The essential add-in for
Excel users. FREE excel ...
(http://www.asap-utilities.com/) they provide a buitl-in function.
Have a nice day
Michael
 
Hi Bobby,
Excel has not such a function, you have to built it by VBA - like Dave
suggested.
But have a look at free ASAP Utilities - The essential add-in for
Excel users. FREE excel ...
 (http://www.asap-utilities.com/) they provide a buitl-in function.
Have a nice day
Michael
Click to expand...

Thank you all guys for your answers! I do have a solution on this but
I was was just wondering if there was something ! had not read.
Regards
 
Back
Top