Is there a way to reference a sheet in a workbook without naming the sheet? In code you have to sayor something like that. I want to write 1 macro that covers all single sheet workbooks.
Please Login or Register to view this content.doesn't work....Please Login or Register to view this content.
Last edited by Tortus; 06-20-2014 at 04:27 PM.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi,
If there is only one sheet then presumably
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
do you have a code that works for a specific sheet ? paste it here, I'll change it for all sheets
If solved remember to mark Thread as solved
Worked! Thank you. Don't know why I didn't think to do that...
Please Login or Register to view this content.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks