Delete Columns if Criteria matched.

[JapanDave]

Hey guys, I am again stumped on the syntax for this code. If someone could take a look at it for me I would appreciate it very much.

I am trying to step through a dynamic range in both columns and rows and delete any columns that have value of "0". In row 1 is the headers for each column.

I think the problem is with the variable "col"???

Please Login or Register  to view this content.

Thanks

[nilem]

maybe so

Please Login or Register  to view this content.

[JapanDave]

nilem, thanks for that.

Could you explain how this line stores the columns to be deleted? I can't get my head around it???

Please Login or Register  to view this content.

[nilem]

We combine cells of certain columns to be removed in the range 'colDe'. And then delete the columns at a time.
It's faster than deleting columns in series in the loop.

[JapanDave]

Thanks for the explanation, but I still can't see how that code stores the data? I thought you needed something like "Static" to store the data collected by the code?

[nilem]

Let's try again

Please Login or Register  to view this content.

i - the column number that we are going to remove.
.Cells (1, i) - a cell of the column we are going to remove it.
colDel- this is unrelated range of cells belonging to the columns that we are going to remove it.

[JapanDave]

Ahh, I see now.
And please forgive the questions.
However, I don't know how you can set the same variable twice?

[nilem]

...However, I don't know how you can set the same variable twice?

You mean 'colDel' variable?
Try this code for example.

Please Login or Register  to view this content.

[JapanDave]

Hey Nilem,
I have got now. Thanks so much for the detailed explanation. The union ties the ranges together, then you can act on that how ever you want.

Dave