PDA

View Full Version : Deleting Blank Rows in VBA Code



Rosalena
11-02-2021, 11:00 AM
Hi Guys,
I am new to VBA coding and I want some help by providing me a code to fill blank rows in a file.

Appreciate your response,

Regards,

p45cal
11-02-2021, 12:45 PM
Attach a file and say which blank cells you want filling.

jolivanes
11-02-2021, 01:42 PM
At one place you say "Deleting Blank Rows in VBA Code" and in the Post you ask for help to "fill blank rows in a file".
Two opposites!
One thing to remember is also that sometimes cell appear empty but they have a non printable character.
As p45cal suggested, attach an example file.

Paul_Hossler
11-02-2021, 02:25 PM
Hi Guys,
I am new to VBA coding and I want some help by providing me a code to fill blank rows in a file.


I'm going to assume that you meant you want to delete blank rows by filling them with something so that they're no longer blank ???

What do you want to fill them with?

p45cal
11-02-2021, 03:16 PM
Is this you?
https://chandoo.org/forum/threads/delete-empty-rows.47128/
and this:
https://www.excelforum.com/excel-programming-vba-macros/1363114-deleting-blanked-rows-in-vba-code.html