VBA Macro to Google Sheet Macro (1 Viewer)

Manikarthisnr

New member
Local time
Tomorrow, 03:15
Joined
May 30, 2017
Messages
3
Dear Experts,

I have visited many forums but my problem never gets resolved. Today, I feel am @ right place. Hope, experts will help me.

Am a new member to this forum and its my first post. I have a Excel VBA code that needs to be converted/done into Google Sheet Macro

Sub test()
Dim i As Long, ii As Long, x As Range
Application.ScreenUpdating = False
With Sheets.Add
Sheets("input").Columns(1).Copy .Cells(1)
For i = 2 To .Range("a" & Rows.Count).End(xlUp).Row
If .Cells(i, 1).Hyperlinks.Count Then
ii = 1
Do While .Cells(i + ii, 1).Hyperlinks.Count
If x Is Nothing Then
Set x = .Rows(i)
Else
Set x = Union(x, .Rows(i))
End If
ii = ii + 1
Loop
End If
Next
If Not x Is Nothing Then x.Delete
End With
Application.ScreenUpdating = True
End Sub

Am trying it for past 10days. Plz help me.

Thanks in advance.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 21:45
Joined
Jul 9, 2003
Messages
16,245
You want Bruce McPherson desktop liberation see his website here:-

http://ramblings.mcpher.com

There's also a Google Plus Group I think you'll find a link to it on Bruce's website.

Bruce has created many functions in Google sheets which emulate functions from VBA.

He has also written an excellent book on it and done some videos.

You can get access to his book and videos for free on safari books online. I believe they are still offering a one month free evaluation period.

Sent from my SM-G925F using Tapatalk
 

Manikarthisnr

New member
Local time
Tomorrow, 03:15
Joined
May 30, 2017
Messages
3
Any other help? Totally am blank about Google Apps script
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 21:45
Joined
Jul 9, 2003
Messages
16,245
Any other help? Totally am blank about Google Apps script
Well, this is a mostly VBA site, so I'm a bit confused as why you would expect to get some help here, but you never know!

Sent from my SM-G925F using Tapatalk
 

Manikarthisnr

New member
Local time
Tomorrow, 03:15
Joined
May 30, 2017
Messages
3
Yes, U r right. But I have seen some post like this in same forum and gets solved by experts like you.
 

Users who are viewing this thread

Top Bottom