I'd like to select and delete a range of columns on a
worksheet which are identified by each containing a value
of 0 in row 3, (they are sorted so they are grouped
together as well which makes it handy). The other columns
will each contain a value 0 in row 3. I'm tying to suss
out the following
Would I use a Do Loop or a For Next?
Would I work left to right, or right to left using a step -
1 type statement
there is already a variable called lastcol that contains
the last used column
Once the columns are identified a need to delete the
entire column
Can anyone help with the syntax.
Many thanks
Jacqui