VBA Macro to Google Sheet Macro

[Manikarthisnr]

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]

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]

Any other help? Totally am blank about Google Apps script

 

[Uncle Gizmo]

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]

Yes, U r right. But I have seen some post like this in same forum and gets solved by experts like you.

 

[Uncle Gizmo]

Bruce just posted in the Google Apps Script G+ Group, here's the link:-

https://plus.google.com/+BruceMcpherson/posts/AXQpemSkCGm

Sent from my SM-G925F using Tapatalk