Record Macro for variable array

[SimonHughes]

I need to format a data array which is fixed in width (columns A:X) but variable in length so the array could be A1:X5 or A1:X1000 or whatever.
How do I record a macro (I cannot do VBA) that will place the cursor in column A at the last row in the array?

Any help gratefully received. I am using Excel 365

 

[James006]

Hi,

To be tested

Sub Test()
Application.Goto Cells(ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row, 1)
End Sub

 

[zero269]

I need to format a data array which is fixed in width (columns A:X) but variable in length so the array could be A1:X5 or A1:X1000 or whatever.
How do I record a macro (I cannot do VBA) that will place the cursor in column A at the last row in the array?

Any help gratefully received. I am using Excel 365

You should be able to use the shortcut keys CTRL + Down Arrow to go to the bottom Row of a column and CTRL + Right Arrow to go to the last Column in the Row.
Another thing you may want to try when recording your macros is to turn on Relative References on the Developer tab to compare the differences.

 

[SimonHughes]

Hi,

To be tested

Sub Test()
Application.Goto Cells(ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row, 1)
End Sub

That works perfectly, many thanks

 

[James006]

You are welcome