Jaspreet Singh Anand
asked on
Can anyone write a small code for Google scripts
Hi,
I am using a small code in Excel but know need to use it in Google Sheets,but im not able to convert the code to google sheets
Please help.
Code as below:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim temp As Range, max As Range, min As Range
Set temp = Range("A2")
Set max = Range("B2")
Set min = Range("C2")
If Not Intersect(temp, Target) Is Nothing Then
max = WorksheetFunction.max(Targ et, max)
min = WorksheetFunction.min(Targ et, min)
End If
End Sub
Thanks and Regards
I am using a small code in Excel but know need to use it in Google Sheets,but im not able to convert the code to google sheets
Please help.
Code as below:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim temp As Range, max As Range, min As Range
Set temp = Range("A2")
Set max = Range("B2")
Set min = Range("C2")
If Not Intersect(temp, Target) Is Nothing Then
max = WorksheetFunction.max(Targ
min = WorksheetFunction.min(Targ
End If
End Sub
Thanks and Regards
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
I believe you can utilize Google Apps Scripting with Google Sheets to write your code.