Link to home
Start Free TrialLog in
Avatar of printmedia
printmedia

asked on

replace blank cells with 0 starting with a specific column until no more data Excel VBA

Hi all.

At first I used the following code
ActiveSheet.Cells.SpecialCells(xlBlanks).Value = 0

Open in new window


to replace any blank cells with 0 but then I realized that some cells in columns A-G are supposed to be blank and therefore should not have 0. I want to start replacing blank cells with 0 starting in cell H2 and then go down the H column and to the right until there is no more data to check. I don't know how many columns and rows come after column H because it's based on end user parameters. Sometimes there will be columns H-K and there will be 40 rows, other times there could be columns H-P with only 5 rows.

Any help would be appreciated. Thank you in advance!
SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial