cell resets to "0" with deleted column

[mryan1962]

I have a spreadsheet that has a macro to manipulate cells. I am using vb to select a column and then delete the column. When i do this, two cells in another column are set to "0". There is nothing special with these two cells, just general formatting with a part number value. The remainder of column that these two cells reside in are not affected. I have tried just copying an unaffected cell in to these two cells, but the value still gets set to "0". Can anybody help?

[dilipandey]

Hi mryan,

Welcome to the forum.

Commenting anything without seeing the spreadsheet will not help... may be custom formatting or some formulation or through vb code anything could be a reason for that, suggest you to upload that file / that sheet tab. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>