VBA Change blanks to zero's in one column in usedrange

[coetzej9]

Hi,

My named ranges are dynamically set, but does not match in size because of blanks in one column. I have not been able to track VBA down to change blanks to zero's in only one column WITHIN the used range which I called "MyRange" (I used VBA to dynamically extend as rows are added. I have a set number of columns)

Thanks in advance.

coetzej9

 

[Joe4]

I am not sure I follow/understand what you are working with and what you are trying to do.
Can you walk us through an actual example, and post any VBA code you are currently using?