referencing a sheet in a list box

  • Thread starter Thread starter Dave_Russell
  • Start date Start date
D

Dave_Russell

Thank You Electra!

That worked well. I am sure I tried using INDIRECT before, but
obviously I did it incorrectly. That should allow me to accomplis
what I need.

Perhaps you or someone else could assist me with the second part of m
question then. Is there a way to collect the names of the sheet tabs
(sheet1, sheet2, sheet3, etc....), and make those names available fo
use in the list box?

Dave Russel
 
No Dave I can't help with that part it is beyond my knowledge. I
think you should repost that part of the question. Others should know
the answer. also did you see Franks answer posted Nov 2 2004 under
the title : One more time - substitutions. that seems to be related
to what you asked.
 
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 formula referencing cells 4
Another quick question! Thanks! 5
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Please help with Excel Formula 2
Please help with code. Thanks! 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
referencing a sheet in a list box 2
Sheet name in formula 2

Back
Top