Select Cell from value of another cell

[TIMSHARPEUK]

Hi all.

I'm new here and new to macros.

I have a workbook, it is essentially a pilots flying logbook. On one sheet I have cell which contains a formula to return the row number for row the next new entry should be entered onto.

Eventually I will want to have a form with controls (text boxes etc.) and when a save button is pressed id like it to copy the data entered by use of these controls, into cells of the next row of the worksheet, like entering a new entry in a database.

As part of my build up to this I was trying to work out how I can use a macro to select the cell in col.A of the next empty row.

So far I have a column labelled index and contains consecutive number for each row (A1=Index, A2=1, A3=2, A4=3...) and a formula which returns the row number of the highest number,+1(to give the first empty row)...MATCH(MAX(A:A),A:A,0)+1 and I have added an A to the beginning of the result using "A"&. Result is a Cell with a calculated value of something like "A6" when the number is variable. It is this cell that I want my macro to select.

Any advice? sorry if there is not enough info or its not clear what I am trying to do.

also, if it matters, the formula I put here isn't exactly what It is in my cell as I have used names and formula in other cells but that is basically what it is doing.

Cheers guys,

Tim

[stnkynts]

Is your question simply "how I can use a macro to select the cell in col.A of the next empty row."?

If so then

Please Login or Register  to view this content.