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
 
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
 
You must log in or register to reply here.

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

Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1
Table with many Column Names - How to efficiently generate a list ofhyperlinks to each Column Header 1
Pivot table report invalid 0
Indexing for data found within a Table Query 2
unable to add row to Excel 2007 TABLE 3
MS Outlook VBA- editing an empty value of a task item 0
Power Pivot Question - Adding a column from the Source Table 1
Building closed workbook file path within an Index Function 6

Back
Top