Macro to find a specific cell in the last column of data

[todd18us]

I have a table that goes from from A to G and from row 14 to 53. I want to perform a calculation in Cell C55 that locates the value in row 28 of the last column with data. In this current case the last column is row G. However, in future calculations the last column could be H or I. Therefore, I need a program that determines the number in the cell of row 28 and the last column of data.

Thank you,

[todd18us]

Any help is greatly appreciated.

[Alf]

Perhaps something like this?

Please Login or Register  to view this content.

and the value in row 28 and last column

Please Login or Register  to view this content.

Alf