"capturing" an address?
Posted by Bill on December 12, 1999 9:23 AM
How might I modify the module above so that it
looks at sheet1 cell B2 and select a sheet with
the same name ? ( cell B2 changes daily)
I've done this in Quattro Pro using &"****"&
in my formulas but havent found a solution in Excel, hope you can give me a clue.