Profile

Cover photo
Ben Liebrand
Lives in Leeds, Yorkshire, England
6,282 followers|1,201,878 views
AboutPostsPhotosYouTubeReviews

Stream

Ben Liebrand

Problem/Coding Help  - 
 
I'm new to Scripts and trying to accomplish something. Some help with this would be appreciated.

I have tested the Script below and in general terms it is working fine.

But in my case I have formulas in some columns that is causing this script not to give me the result I want.

I am trying to position the cursor in the next empty cell in column A that does not have any data in it so I need this script to only determine this based on column A regardless of the formulas in other columns. I realize this Script is looking at the entire range.

The idea is to get to the next empty cell in Column A on opening the spreadsheet. (That part I have got working when the spreadsheet is opened) 

function lastRow() {

  // ** This positions the cursor at the next empty row
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var sheet = ss.getActiveSheet();
   var lastRow = sheet.getLastRow()+1;     // to get then next empty row
   sheet.setActiveSelection(sheet.getRange("A"+lastRow));
   
 }
1
1
Jean-Pierre Verhulst's profile photoBen Liebrand's profile photoJoris Steurs's profile photo
8 comments
 
+Jean-Pierre Verhulst Yes, now that you have shown what it means I fully understand what it is for.

I will also test the script example you supplied.

Thank you for your help and feedback.
Add a comment...
 
I just took this shot a few minutes ago of the sunset over Leeds, Yorkshire, England.
Samsung Galaxy S3

#Sunset   #Leeds   #yorkshire   #England  
9
Simmie Reagor's profile photoLuise Healey's profile photoBen Liebrand's profile photo
4 comments
 
+Luise Healey Thank you.
Add a comment...

Ben Liebrand

Shared publicly  - 
 
HOW TO TAKE A TIRE OFF A CAR WHEEL AND PUT IT BACK ON AGAIN IN A FEW SECONDS WITHOUT TOUCHING IT

h/t +Robert Fields Jr. 
3
ken newman's profile photoBen Liebrand's profile photo
4 comments
 
+ken newman yeah, but that wouldn't be fun :-) 
Add a comment...
 
 
I posted this picture on the 8th March but for some unknown reason it loaded at the wrong size an look terrible. So I decided to post it again.

I took this picture at the Washburn River near the Thruscross Reservoir. This my son +Mark Liebrand​ kayaking on this river.
Samsung Galaxy S3

#washburn #Yorkshire #England #kayak #thuscrossreservoir
12
Chasing Orgasm author Roland J. Ruttledge's profile photoLuise Healey's profile photoSteve Gould's profile photoBen Liebrand's profile photo
8 comments
 
+Steve Gould thank you for your comment. I'm glad you like it. 
Add a comment...
 
I took these sunset pictures in the Leeds Area, Yorkshire, England
Both pictures are the same sunset a few minutes apart.
Samsung Galaxy S3

#leeds   #yorkshire   #england   #sunset  
13
ken newman's profile photoRichard Pabon's profile photoLuise Healey's profile photoBen Liebrand's profile photo
8 comments
 
+Luise Healey no kidding! No time to think about the shot.
Add a comment...
 
I took this picture at the Washburn River near the Thruscross Reservoir. This my son +Mark Liebrand​ kayaking on this river. As I pointed out on one of the pictures I posted early of this river I mentioned that the water always has a black look to it as shown here but in the other picture it has a blue look from a different angle.
Samsung Galaxy S3

#washburn #Yorkshire #England #kayak #thuscrossreservoir
7
Tessa Schlesinger's profile photoPan Aveyard's profile photoBen Liebrand's profile photoMark Liebrand's profile photo
7 comments
 
+Pan Aveyard it is very fun
Add a comment...
 
I took this picture at the Washburn River near the Thruscross Reservoir where my son +Mark Liebrand​ kayaks. Generally the water in this river has a black look to it but from this angle it looked blue.
Samsung Galaxy S3

#washburn #Yorkshire #England #kayak #thuscrossreservoir
8
Luise Healey's profile photoBen Liebrand's profile photo
2 comments
 
+Luise Healey I'm glad you like this picture.
Add a comment...
Have him in circles
6,282 people
Recreo Clothing's profile photo
PR Plumley's profile photo
Osmanlı Torunu's profile photo
maryan jane's profile photo
Ольга Печерских's profile photo
YTube Manager's profile photo
TITANY CLUB's profile photo
léa raphaël's profile photo
Car Crash Tube's profile photo
 
Sunset Glow over Leeds, Yorkshire, England
Samsung Galaxy S3

#sunset #Leeds #Yorkshire #England
12
Luise Healey's profile photoSteve Gould's profile photoSimmie Reagor's profile photoBen Liebrand's profile photo
8 comments
 
+Simmie Reagor thank you for your comment. I'm glad you like. I am just about to post another shot of the same area I have just take.
Add a comment...
 
This is a shot I took a the sunset over Leeds, Yorkshire, England
Samsung Galaxy S3

12
1
ken newman's profile photoDi S's profile photoBen Liebrand's profile photoNerguibaatar Tegshjargal's profile photo
4 comments
 
+Di S thank you. I'm glad to hear you like it. 
Add a comment...

Ben Liebrand

Shared publicly  - 
 
Okay, I dare you take this job away from this guy!
4
Hugo Schockman's profile photoDonald Morris's profile photoCorrie Ludwig's profile photoBen Liebrand's profile photo
6 comments
 
+Corrie Ludwig you are welcome. I guess this guy has a unique talent. 
Add a comment...
 
I took this picture at the Washburn River near the Thruscross Reservoir where my son +Mark Liebrand​ kayaks. The colours looked quite striking.
Samsung Galaxy S3

#washburn  #Yorkshire   #England   #kayak   #thuscrossreservoir 
7
Alexandre Fagundes de Fagundes's profile photoPål Basso's profile photoSteve Gould's profile photoBen Liebrand's profile photo
8 comments
 
+Alexandre Fagundes de Fagundes thank you for your comment. I'm glad you like it. 
Add a comment...
 
I took this picture at the Washburn River near the Thruscross Reservoir where my son +Mark Liebrand​ kayaks. This is one of the trees hanging over the river and has a good layer of moss covering it. It looks pretty amazing to see how green many trees are.
Samsung Galaxy S3

#washburn #Yorkshire #England #kayak #thuscrossreservoir
7
Chasing Orgasm author Roland J. Ruttledge's profile photoLuise Healey's profile photoBen Liebrand's profile photo
4 comments
 
+Chasing Orgasm author Roland J. Ruttledge
Thank you. I appreciate that.
Add a comment...
People
Have him in circles
6,282 people
Recreo Clothing's profile photo
PR Plumley's profile photo
Osmanlı Torunu's profile photo
maryan jane's profile photo
Ольга Печерских's profile photo
YTube Manager's profile photo
TITANY CLUB's profile photo
léa raphaël's profile photo
Car Crash Tube's profile photo
Basic Information
Gender
Male
Relationship
Married
Story
Introduction
I like technology. I also like taking pictures of things I find interesting, though I am not a professional at this. I take all my pictures with my smartphone. Most of the pictures I post are ones I have taken. 
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Leeds, Yorkshire, England
Links
Outstanding food at very reasonable prices. Excellent value for money.
Public - a year ago
reviewed a year ago
1 review
Map
Map
Map