Microsoft Excel Office Script

[jerryr125]

Hi - I am using an Excel Workbook in the Microsoft Office 365 platform.

I am creating Microsoft Office Script to automate a process.
I would like to set a variable in the script to a value in the Excel Workbook from a specific sheet and cell.

Example:
In the Microsoft Office Script I have the variable "RowCounter01"
In my Workbook I have Sheet ("RDate") and in the Sheet a specific cell with a value (cell "J1").
How do I code the automated script to set the RowCounter01 variable to the value in RDate, cell J1 ?

If the value in J1 is 123 then RowCounter01 would be set to 123.
Any assistance is appreciated - thank you - jerryr125

 

[kweaver]

I suspect you mean: RowCounter01 = Sheets("RDate").Cells(1, "J")