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
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!
At first I used the following code
ActiveSheet.Cells.SpecialCells(xlBlanks).Value = 0
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.