What is the best method in VBA to find last populated cell in each row and select/activate

[Calieth]

I have a spreadsheet of work instructions that will contain drawings via Hyperlink. I wish users to be able to click a Button or use a User Form to enter their WP(work package) number, and then have it open all of the most recent versions of the associated drawings.

I've already got what I need to have them enter the WP# and have it select the correct worksheet. Now I am working on a way for it to automatically open all of the correct Hyperlinks. (I have a way for it to open all of the Hyperlinks on the page, but that is not what I need) Correct = the last Hyperlink in each row. (The latest version of the drawing).

One way that seems like it might work is to use FindAll. I can get it to work to look for text (like "Cat), but am having trouble with code to get it to find the last populated cell in each row, and to select them or to activate the hyperlinks.


Can anyone tell me if FindAll is what I am looking for this in this instance? And then suggest how to properly specify the last cell in each row. Or let me know if I should be using something else to do so.

I have attatched a sample of the workbook and the second tab contains Hyperlinks. My ideal end result would be for it to automatically open the Hyperlinks in Cells (D3, C5, C6, E7, D10) (I will highlight these in green, in case Hyperlinks do not show up) which are the last populated cells in each row.
Now, clearly the hyperlinks will not work as they link to files on my work server. But I hope it will still provide the idea of what it is supposed to do.)

Please let me know if there is other information that I should provide. And thank you very much for taking a look at this.Sample Master Drawing Index(1).xlsm

[Calieth]

I have a spreadsheet of work instructions that will contain drawings via Hyperlink. I wish users to be able to click a Button or use a User Form to enter their WP(work package) number, and then have it open all of the most recent versions of the associated drawings.

I've already got what I need to have them enter the WP# and have it select the correct worksheet. Now I am working on a way for it to automatically open all of the correct Hyperlinks. (I have a way for it to open all of the Hyperlinks on the page, but that is not what I need) Correct = the last Hyperlink in each row. (The latest version of the drawing).

One way that seems like it might work is to use FindAll. I can get it to work to look for text (like "Cat), but am having trouble with code to get it to find the last populated cell in each row, and to select them or to activate the hyperlinks.


Can anyone tell me if FindAll is what I am looking for this in this instance? And then suggest how to properly specify the last cell in each row. Or let me know if I should be using something else to do so.

I have attatched a sample of the workbook and the second tab contains Hyperlinks. My ideal end result would be for it to automatically open the Hyperlinks in Cells (D3, C5, C6, E7, D10) (I will highlight these in green, in case Hyperlinks do not show up) which are the last populated cells in each row.
Now, clearly the hyperlinks will not work as they link to files on my work server. But I hope it will still provide the idea of what it is supposed to do.)

Please let me know if there is other information that I should provide. And thank you very much for taking a look at this.Attachment 183021

I would actually even be really happy with help just with selecting the last populated cell in each row. I've tried many methods, but my language skills are just not advanced enough to find this solution.

If I can get it to select the last populated cell in each row, I can figure out the rest of what I need on my own.

Thanks!