how to ref or find the last active cell in a column or row?

[Princy557]

It's a while ago, but still have no real answer.
How do you get a cell ID, which is the final active cell in a row or column?

[SuperTech]

There is no direct function available, but you can try BasicMaker script for this.

[Princy557]

Hi Supertech, thanks for the reply.

I'm looking at making entries numerous times daily, showing date, time, and two columns of data.
Possibly as if interest rates/prices change as and when (some days no entry).
I must find the latest entry in the 4 columns (Col A).
Is there a way of finding the first empty cell in a column?
I find it quite difficult to think that there is NO actual command or function to do this???

No idea how to use BasicMaker to work it out.

Any further advice, please?

Sorry for the slowness in responding. I am disabled and sometimes getting upstairs to my office is difficult and painful.
Regards

[SuperTech]

I must find the latest entry in the 4 columns (Col A).
Is there a way of finding the first empty cell in a column?

I found a solution for you. Here's a solution to find the latest blank cell in column A (with a maximum range of 500 rows):

1. Use this array formula:

Code: Select all

=MIN(IF(A1:A23="",ROW(A1:A23))) 

2. To implement:

• Copy the formula above

• Paste it into your desired cell

• Press Ctrl+Shift+Enter to enter it as an array formula

• The result will show the row number of the first blank cell

Note: This formula assumes your data is in range A1:A500. Adjust the range as needed for your specific worksheet.

[Princy557]

Thanks for that,
I'm testing and have 90% success rate, but that's me, I think I am doing things in the wrong order. The last few times tested seem to have worked OK.
great result for me, again thanks for the assist with that one.