Đã hoàn thành

Write small code in Google scripts

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)

End If

End Sub

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.

Kĩ năng: Google App Engine

Xem nhiều hơn: google script for loop, google apps script for beginners, google sheets programming with google apps script (2015 revision complete), google spreadsheet script get cell value, google sheets script examples, google sheets script functions, google apps script tutorial pdf, google apps script web app, write essay include these words last time i saw them, i use a google translator i just wanted to say that i love we heart it mit jelent ez a mondat, i need a computer programmer to write a code for me, which application should i use to write article with pics, write-small-code-for-hadoop, modify python code and write small report, vba code google calendar

Về Bên Thuê:
( 0 nhận xét ) delhi, India

ID dự án: #15167763

Được trao cho:


Hi, my name is Kaio Stricker and I would like to help you in your task. Relevant Skills and Experience Plenty Excel experience, already know how to solve your problem. If you choose me, I'll send you the solution as s Thêm

₹850 INR trong 1 ngày
(0 Đánh Giá)

4 freelancer đang chào giá trung bình ₹1050 cho công việc này


I have excellent command on Google Sheets and MS Excel. I have completed complex projects before involving Macros. You can see the reviews of the same in my profile Relevant Skills and Experience I know how to execut Thêm

₹1300 INR trong 1 ngày
(7 Nhận xét)

‌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.

₹1450 INR trong 1 ngày
(0 Nhận xét)

This will done in one day(less than 24hrs). Relevant Skills and Experience Have created many script Proposed Milestones ₹600 INR - work complete You will share existing googlesheet or i create new with script or ema Thêm

₹600 INR trong 1 ngày
(0 Nhận xét)