Go To Row 1 of Last Active Column

[Tellm]

I have a large quantity of data that I import into my spreadsheet and its all over the place. I want to simply find the last active column of that data (which will vary on each days data sent in) and then go to row 1 of that column.

Thanks

[Solus Rankin]

Press the home button. and then ctrl + end.

[Tellm]

Solus thanks for the response. Pressing Home takes me to column A and Ctrl + End will take me to A1 or wherever the next space is. THANKS

[LaffyAffy13]

If you need it in code:

Please Login or Register  to view this content.

[Tellm]

Laffy again thanks - I am probably not explaining myself - as I said the data is all over the place so in my macro I will use "Go to Last Cell" it is then that I want to go to row 1 of that column. By using your code I only go to the last active cell in row 1 whereas in row 1001 it could be a further 10 columns along. Thanks

[Solus Rankin]

ctrl + end will always take you to the furthest right column. The ctrl 'up arrow' will take you to the top of that column.

Are you trying to code this into the macro or do you just need to get there?

[Tellm]

Solus- I am trying to code this - I need to find the last cell and then whatever column that is go to to row 1 of that column. When I use the Ctrl 'Up Arrow' it doesn't take me to row 1 but to the next row that has data in it which could be the next cell up. Thanks again

[Solus Rankin]

Try:

Please Login or Register  to view this content.

[LaffyAffy13]

Solus's last post works, just take out the "Offset". So this:

Please Login or Register  to view this content.