Hi There
What formula may I use to to generate the address of a cell which holds a unique value in a workbook? The value would always be in the first colum A of the worksheet it is in. If I was searching within only one worksheet I could use a vlookup but the workbook has dozens of sheets, and I need an all purpose formula to look or search within the entire workbook.
Cheers
Michael
Hi Michael,
I am not sure how to obtain this with formula. For sure you can use simple macro, like:
At the moment it works this way that current worksheet is excluded from search - if it shall be included - remove two apostrophes (comment signs) from the code If wks.Name ... and respective End if
Please Login or Register to view this content.
The result is now written into active cell - but of course you can change it in a way you want ;-)
Write some texts in the attachment in columns A of different Sheets and try how it works.
Best Regards,
Kaper
Thread posted in Commercial Services, hence closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks