Activate last cell in a column with a given value

[bsrivatsa]

Hi,

I have a column list with repeating values a,b,c,d,e and f. How to I identify and activate the cell containing, for e.g. the last "e" to do further actions with it ?

Thanks

[GC Excel]

Hi,

Assuming you select your column, this macro will "activitate" the last cell containing "e"

Please Login or Register  to view this content.

You might need to adapt according to your file.

[Fluff13]

Maybe something like

Please Login or Register  to view this content.

[bsrivatsa]

Thanks this works!

[bsrivatsa]

Thanks, This works

[Fluff13]

Glad we could help & thanks for the feedback

[bsrivatsa]

Hi,

Assuming you select your column, this macro will "activitate" the last cell containing "e"

Please Login or Register  to view this content.

You might need to adapt according to your file.

Thanks for this solution.

Can you also advise how to instruct to look for another letter if the first one isn't in the list? To clarify, if the column doesn't have an "e", how to look for the last "d"?
Thanks

[GC Excel]

Hi,

Here's a new code allowing you to search for multiples values in a list until a match is found.
for example, if "e" is not found, then "d" will be searched.
if "d" is not found, then "c" will be searched, etc...

Please Login or Register  to view this content.