Delete same columns in every worksheet

[Domenic]

This one hurts my head!

I can understand how it can be frustrating when you feel that a certain
code should work and, in fact, it doesn't. Well, at least not with my
Mac.

Thanks for sticking with me.

No, I should be thanking you for sticking with me!

And maybe you could post your question (and results) on:

microsoft.public.mac.office.excel

to see if they could duplicate your results.

Will do. I too am curious.

 

[Domenic]

I thought I'd keep you posted.

So far, JE McGimpsey has tried the code on two versions of Excel (XL04
and XLvX) for the Mac. On both occasions he had no problems.

Bob Greenblatt suggested changing the reference to the columns from...

....range("a1:c1,m1:q1")...

to

....range("a:c,m:q")...

But that too didn't work. I got the same results. So I don't know if
there's something going on with my copy of Excel.

 

[Dave Peterson]

Thanks for posting back.

Do you have any workbook/worksheet events that are firing that may be
interfering with the "simple" macro?

 

[Dave Peterson]

And I'm not sure if you ever tested this against a brand new
workbook/worksheets?

Did you (and what were your results)?

 

[Domenic]

Do you have any workbook/worksheet events that are firing that may be
interfering with the "simple" macro?

I had an add-in in my Excel Start-Up folder. I removed it, tried it
again, and still got the same results. I also tried removing the
Analysis ToolkPak add-in as an extra measure, but still nothing.

And I'm not sure if you ever tested this against a brand new
workbook/worksheets?

Every time I test it, I use a brand new workbook.

JE has suggested I visit his website to troubleshoot this situation.
I'll have to do just that and hope that I can get to the bottom of this.

 

[Domenic]

Well, Bernard Rey has weighed in with his results. He tried running the
code on his French versions of Excel (XL04 and XLvX) and had no problems.

So it's definitely something to do with my end...

 

[Dave Peterson]

Hmmmmmmm.

(that's all I got!)

Well, Bernard Rey has weighed in with his results. He tried running the
code on his French versions of Excel (XL04 and XLvX) and had no problems.

So it's definitely something to do with my end...

 

[Domenic]

Hmmmmmmm.

(that's all I got!)

Well...it looks like I've tried everything. I followed the steps as
suggested in JE's website for troubleshooting, including removing and
re-installing Microsoft Office, but nothing helped.

With a number of people now having weighed in with their results and no
one having any problems, it looks like the problem may have something to
do with my copy of Excel/VBA application.

I can see why you found it so difficult to believe that the macro didn't
work for me.

Not sure where I go from here but thank you, Dave, for your help with
this.

 

[Domenic]

Dave,

I found the problem. Your code works perfectly, the problem was with
me. I feel like such a fool.

I was looking for the macro to actually clear the contents of the
columns specified, but didn't realized that the code actually deleted
the columns, which as you know shifts them left.

So that explains why Columns S through Z were empty. After deleting the
named columns, it shifted everything left. And with my sample data
being "a"'s in all cells, I didn't realize what was happening.

And to think of all the time I spent working on this, including
re-installing Microsoft Office. And of course, all the time spent by
you and others trying to help me. I really appreciate it!

This is a h-u-g-e relief! I can definitely rest easier now knowing
there's nothing wrong with my Excel/VBA Application.

Dave, thanks again for your help!

 

[Dave Peterson]

Whew!

I'm glad you found your, er, solution <vbg>.

And it's nice to know that your version of excel isn't special.

or...

Maybe some of my friends dropped by to help: Jack Daniels and Jose Cuervo.

 

[Domenic]

Whew!

Yep! A big affirmative on that one!

And it's nice to know that your version of excel isn't special.

Nope! Only that it's a version behind when it comes to VBA. :-(