Select the last cell in a column based on the value of another cell

**Andrewstupendo** · 04-22-2023, 11:52 AM

Hello All,
I would like VBA language that selects the last cell in a column based on the value of another cell that's not in the column. The attached result tab shows that the last cell in column A, A7, was selected based on the value in cell D4.
If someone could provide coding for this, I would be most appreciative.

Best,
Andrewstupendo

**rollis13** · 04-22-2023, 12:29 PM

You could use this macro to be pasted in a standard module or in the sheet's module.
I'm starting from the bottom because I'm supposing that your last searched date could be anywhere in the column.

Please Login or Register  to view this content.

**jolivanes** · 04-22-2023, 12:35 PM

Please Login or Register  to view this content.

You have to add eror checking if required.

**Andrewstupendo** · 04-28-2023, 03:50 PM

Thanks, this works spendidly.

**Andrewstupendo** · 04-28-2023, 03:51 PM

Thanks, jolivanes, this works spendidly as well.
Best,
Andrew

**jolivanes** · 04-28-2023, 04:49 PM

Thanks for the update, very much appreciated.

Select the last cell in a column based on the value of another cell

LinkBack

Thread Tools

Rate This Thread

Display

Select the last cell in a column based on the value of another cell

Re: Select the last cell in a column based on the value of another cell

Re: Select the last cell in a column based on the value of another cell

Re: Select the last cell in a column based on the value of another cell

Re: Select the last cell in a column based on the value of another cell

Re: Select the last cell in a column based on the value of another cell

Thread Information

Users Browsing this Thread

Similar Threads

Select a cell based on column and Row search

[SOLVED] VBA to select A Range Based on A a fixed cell then the last cell in the Column with Data

[SOLVED] Select cell based on value, copy row of select cell and paste into rows in other workbook

[SOLVED] select entire column based on activecell - multiply cells based if found empty cell

Select cell based on the last entry in other column

select column based on cell input

Select a column based on a cell entry

Bookmarks

Bookmarks

Posting Permissions