Hi all,
As usual had a reasonably thorough Google and cannot find an answer so I hope you don't mind me asking another question.
I'm trying to make a list of all the tab names in a spreadsheet, that's easy enough, but I would also like to copy the data into the adjacent cells of 3 specific cells E2, E3 & S37 from each sheet.
Below is the macro I currently use to list the sheet names.
As always any advise greatly appreciated and thanks for looking.
Please Login or Register to view this content.
Last edited by JohnDoh; 03-18-2016 at 06:47 AM.
Thia assumes info on sheet1 so change to suit:
Please Login or Register to view this content.
Hi JohnDoh
please find the attached sheet and let me know is it what your looking for
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Gentlemen thank you for the almost instant replies, both solutions worked perfectly, you have saved me a lot of work both now and in the future.
Glad to help
please close the thread if you happy with the solution and click on Add Reputation to respective member.
thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks