Link to home
Start Free TrialLog in
Avatar of Jaspreet Singh Anand
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(Target, max)
        min = WorksheetFunction.min(Target, min)
    End If
    End Sub



Thanks and Regards
Avatar of Deborah Canales
Deborah Canales
Flag of United States of America image

Hello,

I believe you can utilize Google Apps Scripting with Google Sheets to write your code.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.