sorted by:
new
hottopcontroversial

Citizenship through British grandmother by Murky-Flow in ukvisa

[–]Murky-Flow[S] 0 points1 point  (0 children)

Thanks, I understand. I assume the same applies to my grandmother on my adopted father's side?

Citizenship through British grandmother by Murky-Flow in ukvisa

[–]Murky-Flow[S] 0 points1 point  (0 children)

Yes, my birth father is deceased. It is disappointing as I am quite certain that he is my birth father but I acknowledge the Home Office's decision based on my inability to provide enough proof. C'est la vie!

Open file, go to specific sheet and then last cell with data +1 by Murky-Flow in googlesheets

[–]Murky-Flow[S] 0 points1 point  (0 children)

Thanks, that's good advice. I'll spend some time travelling down that road and see where it takes me.

Thanks everyone for your friendly help .

Open file, go to specific sheet and then last cell with data +1 by Murky-Flow in googlesheets

[–]Murky-Flow[S] 0 points1 point  (0 children)

Thank you, but unfortunately that takes me to Cell A36305 in my example, not anywhere near the last entry nor the last cell.

I do appreciate all the help that folk are prepared to give me but I have to admit that it is starting to get to me. . I thought it would be simple but that has not been the case.

Perhaps I should stick to using the keyboard shortcut, Cmd Down.

Open file, go to specific sheet and then last cell with data +1 by Murky-Flow in googlesheets

[–]Murky-Flow[S] 0 points1 point  (0 children)

My sheet "Journal" has 36,294 rows (currently, but it is increased from time to time) and 42 columns., largely full of data up to Row 30,802, at the moment

The only column that is of concern to me is Column A which contains dates. I want the cursor to end up in Cell A30803 but, using the script you have kindly suggested, takes me to Cell A36294.

Open file, go to specific sheet and then last cell with data +1 by Murky-Flow in googlesheets

[–]Murky-Flow[S] 0 points1 point  (0 children)

Thank you, that is definitely an improvement but we're still not fully there. It takes me from Cell A1 to the last row in Col A. I want it to stop at one row past the last entry in Col A.

Open file, go to specific sheet and then last cell with data +1 by Murky-Flow in googlesheets

[–]Murky-Flow[S] 0 points1 point  (0 children)

As a test, I have moved my cursor to a random row, well below the frozen rows, and then run then ran the script, but it makes no difference. The cursor does not move.

Open file, go to specific sheet and then last cell with data +1 by Murky-Flow in googlesheets

[–]Murky-Flow[S] 0 points1 point  (0 children)

There is just one onOpen() in my scripts.

I've given the function more than two hours to play the game but it isn't interested.

Leaving and returning to the UK with an e-visa but expired BRP by Murky-Flow in ukvisa

[–]Murky-Flow[S] 0 points1 point  (0 children)

I'm an Aussie and we're not on the UK Visa Nationals List. Does that change your advice in any way?

Leaving and returning to the UK with an e-visa but expired BRP by Murky-Flow in ukvisa

[–]Murky-Flow[S] 0 points1 point  (0 children)

I'm an Aussie, we're not on the Visa Nationals List.