Delete Columns in Multiple Sheets with repeat macro

Hi all -

I'm trying to delete multiple columns which are identical across multiple sheets based on an array which is built using user input.

Through scouring these forums I have gotten this code:

Please Login or Register  to view this content.

The code executes the number of times that there is sheets (as exhibited by the msgbox) but the columns are only deleted on the first sheet.

What do I need to change?

Thanks in advance for your help.

Hi,

Welcome to the forum

Try something like this...

Please Login or Register  to view this content.

I could be wrong, but try prefixing the SelectArray with Worksheets("Start").
i'm thinking that you need a reference to the sheet...
For example:

Please Login or Register  to view this content.

OR....

Please Login or Register  to view this content.

Actually with a little tinkering my husband help me solve it. I had to command the rows on the worksheet.

Here is the fixed code:

Please Login or Register  to view this content.

Thanks again for your replies

Ah... I was on the right track, but you guys figured out the fix
I see it was a need for the sheet reference... I just had it in the wrong place.

Glad you solved it.