Slow process to replace blocks of zeros with null

I have a woksheet that has has 61 Columns.

Column A has a date.
Column B through Column G has 6 different product information for the same entity.
Column H through Column M has 6 differnet product information for the same entity, etc.

I want to find the first non-zero in column B, then in all previous rows above the non-zero I want to have the zeros replaced with an empty cell for the 6 columns of the same entity.

Currently I have the code below but it takes a long time to execute. Is there a way to do this wtih an array and how?

Any help is appreciated, I am definately over my head with my limited knowledge.

Please Login or Register  to view this content.

Sorry for the delay. I tired attaching the file but was told it was too big. I have put it in a zip file. If that does not work for you, then I will eliminate columns and rows. My first time on this board and trying to attach a file so hopefully I did it correctly.

The code is not in the file.

Thank you so much for your help. It is appreciated

Thanks Mike!

Yes, I want in Column B through G to have Rows 2-91 to have a blank cell if there is a zero. If there is not a zero, the data would remain. (For example in column F row 87-91 there is data, so those cells would not change).

Then in Columns H through M, rows 2-1244, zero would be replaced by an empty cell, Columns N through S rows 2-197, zeros would be replaced by an empty cell.

The code I posted does this but since it looks at each cell, the process is slow. I am hoping for a more effecient way.

This data is being used in a graph which is why the zeros need to be empty so they are not plotted until they actually begin.

Again, I appreciate your guidance.

Thank youi! I did a quick test and it worked so fast. Just what I needed.

Can you explain what you did by the steps, so I can understand a little bit better. I understand that the process is doing everything in an array and then putting the results in the new workbook. What I don't understand is how the range is being assigned. For example what does the double i exactly do? I know that is an extra request but I am basically self taught and I would love to get over this hurdle on using arrays.

But no matter if you can take that extra time or not, you really helped. Thank you.

Ari

Thank you again. Breaking the code up as you did was helpful.

Ari