Error: Cannot use that command on overlapping selections. Please help

[ufondu88]

Please Login or Register  to view this content.

Hello all,

I am new to VBA and macros in general. I am having problems with deleting columns from a worksheet. I keep getting an error saying that I cannot use the command on overlapping sections and the error points to the highlighted section, I have unmerged all the cells, so I don't know what the issue could be. Any help with the matter would be helpful. Thanks!

[humdingaling]

can only guess you have a cell selected already and when you try select that big range...it conflicts **shrugs cannot even replicate

to circumvent that selecting just remove the select step altogether

Please Login or Register  to view this content.

oh and i got rid of all the other selects while at it

[jolivanes]

If humdingaling's suggestion/code works for you, you're fine.
If not, how did you unmerge the merged cells? Could it be that you forgot one/some?
Instead of using merged cells, use center across selection.
You could run this if you think that it could be a problem.

Please Login or Register  to view this content.

Or this to change to center across selection

Please Login or Register  to view this content.

[ufondu88]

Thank you so much. That worked perfectly!!

[ufondu88]

can only guess you have a cell selected already and when you try select that big range...it conflicts **shrugs cannot even replicate

to circumvent that selecting just remove the select step altogether

Please Login or Register  to view this content.

oh and i got rid of all the other selects while at it

Thank you so much. That worked perfectly