TAB index table?

[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.

 

[Bernard Liengme]

Could you give an example of what you want to do?
best wishes

 

[Bobby]

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 -

Yes!
If I want to use, let say a TMP Sheet for transfering data and erase
it after I finish with it.

 

[Dave Peterson]

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

 

[Michael.Tarnowski]

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.

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

 

[Bobby]

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

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