Find Jobs
Hire Freelancers

Delete the empty rows

$2-8 USD / hour

Dibatalkan
Disiarkan lebih dari 11 tahun yang lalu

$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
ID Projek: 2482721

Tentang projek

1 cadangan
Projek jarak jauh
Aktif 12 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
1 pekerja bebas membida secara purata $2 USD/jam untuk pekerjaan ini
Avatar Pengguna
Hi, I can do it. Please check the code in PM. Simply add 1 line of code Best regards, Cuong NH
$2 USD dalam 1 hari
5.0 (1 ulasan)
2.0
2.0

Tentang klien

Bendera AUSTRALIA
Sydney, Australia
4.9
31
Kaedah pembayaran disahkan
Ahli sejak Mei 5, 2012

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.