Find Jobs
Hire Freelancers

Delete the empty rows

$2-8 USD / hour

Cancelled
Posted over 11 years ago

$2-8 USD / hour

Hi, I merge this document in a application and it prepopulates the information in the cells (please refer to attached file). If there is no information - then it comes as blank. I have received some line of codes from word forum with a purpose of deletingthe entire rows of the tables; if there is no information populated in the cells - meaning all (fillable cells in a row are blank then delete the entire row). However this code is giving the error of "cannot access the individual rows in this collection because the table has vertically merged cells". I would like to get the correct coding. Current code I have received is: Sub ScratchMacro() 'A quick macro scratch pad created by Greg Maxey Dim i As Long Dim lngCount As Long For i = [login to view URL](1).[login to view URL] To 1 Step -1 lngCount = [login to view URL](1).Rows(i).[login to view URL] * 2 + 2 If Len([login to view URL](1).Rows(i).[login to view URL]) = lngCount Then [login to view URL](1).Rows(i).Delete End If Next End Sub
Project ID: 2482721

About the project

1 proposal
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
1 freelancer is bidding on average $2 USD/hour for this job
User Avatar
Hi, I can do it. Please check the code in PM. Simply add 1 line of code Best regards, Cuong NH
$2 USD in 1 day
5.0 (1 review)
2.0
2.0

About the client

Flag of AUSTRALIA
Sydney, Australia
4.9
31
Payment method verified
Member since May 5, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.