Hi there,
Thanks for all your help with previous problem and works well, I just need one more thing. I was wondering if there is a way that you can get the cells address from a VLOOKUP? Using the code below, once it has found lookFor could it return it's address so in later code I could find the Offset of that cell.Many thanks.
Please Login or Register to view this content.
Hi,
If found is a range then
found.row and found.column
will give you the row and column.
Is that what you wanted?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
What I need is the cell reference of the found item, my spreadsheet is a small production schedule project and the titles are:
NUMBER NAME TYPE SALES PURCHASE
so if found = is a NAME I won't to find the cell reference of that NAME so then I can OFFSET that cell to return the NUMBER, so if the NAME is ROW 123, 123 can be used in the OFFSET. Sorry I'm a beginner.
The best way to understand your need and the answer is for you to produce a simple sample workbook.
You can attach one using the "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area. This will allow you to attach a sample file.
Be sure to show what is given and what you want the outcome to look like.
Hi Here's a simplified version of the spreadsheet.
Thanks again.
Hey - now I see what you were thinking
Look at my code in your userform, where FIND is most likely a better method and what you really want.
When you used VLookup and want the 14 column it would come back with the number that is in column O after it found what you were searching for.
Look at the attached and Userform code.
Re: VLookup and return the cell reference.
Thanks you're a star, just the job.
Thanks again.
Last edited by Fabius; 04-17-2011 at 03:09 PM.
Thanks again very happy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks