Solved determine location of a cell

April 7, 2014 at 14:22:48
Specs: Windows 7
Hi Guys,
Its been a while and I have a question that I can not think of how to solve

I need to determine the cell location of the last data entry in a row. I need help and a response in the form of a formula so that I can add this to one I am working on

The Row, lets say Row 4, has blanks as well as various cells with data in.
I need to be able to determine that cell location.

Any ideas???

See More: determine location of a cell

Report •

April 7, 2014 at 16:59:05
✔ Best Answer
It would help if you defined "data" with a little more specificity.

For numbers or dates something like this should work:


For text, try this:


If you don't know if the data will be a number, a date or text, try this:


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •

April 7, 2014 at 17:20:41
A different interpretation of what is being asked:

User enters first bit of data in Cell A4
User enters second bit of data in Cell X4
User enters Last bit of data in Cell M4

I can think of no formula that could determine the location of the Last data entry cell.
Perhaps a bit of VBA might be able to track the data entry.

Will have to see what Tony is really looking for.


Report •

Related Solutions

Ask Question