I have solved first problem of inserting values into rows.
However I am still looking for way to add value in date format.
Here is updated code:
function replaceStringDate(e) {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2;
var lastRow = SpreadsheetApp.getActiveSheet().getLastRow(
nesday, October 29, 2014 1:10 PM
>Subject: Re: $$Excel-Macros$$ Set Value in Date format in first Empty Column :
>Google Script
>
>
>
>Thanks Paul, this is google scripting for automating google docs/spreadsheets.
>It uses Java Script.
>
>
>
>
>
>
>
>
Thanks Paul, this is google scripting for automating google
docs/spreadsheets. It uses Java Script.
On Wed, Oct 29, 2014 at 5:48 PM, Paul Schreiner
wrote:
> What programming language are you using?
> This seems to be a C++ format?
>
> I'm not sure how you were planning to do this.
> your functi
What programming language are you using?
This seems to be a C++ format?
I'm not sure how you were planning to do this.
your function was passing a variable (e)
but I don't see where you were using it.
Using VBA in Excel, I created a function:
Public Function ReplaceStringDate(Str) As Date
