I use the below code in VBA in excel but i want the same function to be written in google scripts which i want to use in google sheets.
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 = [url removed, login to view](Target, max)
min = [url removed, login to view](Target, min)
Value of A2 keeps changing with time,therefore, What this code does is It records the Highest and Lowest Value from cell A2 to B2 and C2 respectively.
4 freelancers are bidding on average ₹1050 for this job
Hi I am vba developer since 2012 with experience in writing macros for ms excel, word, PowerPoint and ms access. Also i have develop application on vb6. actually there is some issues in chat.