delete cols in vba

[welchs101]

i have this code to delete rows in vba

Please Login or Register  to view this content.

Is there a similar code to delete cols.......i tried this but seem to get an error

Please Login or Register  to view this content.

[jeffreybrown]

How about...

Please Login or Register  to view this content.

If you turn on the macro recorder it will give you the syntax.

[welchs101]

that works..........the reason i was trying to do it the other way (with #s instead of letters) is because i have a value which is equal to the number of cols to delete........so i was hoping i could use numbers.

thanks. if i cant find what i am looking for i am going to use your suggestion.

thanks.

[jeffreybrown]

A very good question I probably don't know the right answer for.

The only thing that strikes me right now is to run something like this, but not sure if I'm barking up the right tree.

Are these columns always going to be next to each other? With this code, if it was column 1 and 2 you want deleted then column 1 would delete first making the old column 2 now column 1 and the for next would run twice.

Please Login or Register  to view this content.

[mikerickson]

If you want to use numbers you could use code like

Please Login or Register  to view this content.

[jeffreybrown]

Hi Mike,

Thanks for the help...sure do appreciate it.

I tried the .Resize method and it didn't work for me, but I see why now.

Any reason why the .Resize works this way...

Please Login or Register  to view this content.

But not...

Please Login or Register  to view this content.

[mikerickson]

No, I don't know why the compiler interprets the omitted argument differently than a 0.
(The Worksheet function INDEX does interpret no argument as 0)

[jeffreybrown]

Okay got it...thanks