Problem selection column (merged cells)

[Defumator]

Good morning,
I have an excel sheet with data in 4 columns, i am want to create a macro that delete the first column, i m using this code:
Columns("A:A").Select
Selection.Delete Shift:=xlToLeft
there is some merged cell (A:D), so the macro select the 4 columns. I learned this code using ''record macro'', but when i select the entire column manually, it just select one column, but when i use the macro, it select all 4.
Is there a way to select just one column with these merged cells??
thank you very much

 

[Joe4]

Welcome to the Board!

I would highly recommend getting rid of the merged cells. They cause nothing but problems (as you can see!), and most serious programmers avoid them at all costs.

You can get the same visual effect by using "Center Across Selection" without all the issues that merged cells cause. Here is a link that talks about that, and how to do that: http://www.officearticles.com/excel/merged_cells_in_microsoft_excel.htm

 

[Defumator]

Thank you!
i don't like using merged cell either! the problem is that the sheet is a report imported from another program (Project Scheduler 7), so i can't change the layout of the report...

 

[Joe4]

As long as you are creating a macro, you can put a line at the very top that will first unmerge all your cells. You should then be able to do what you want after that without issues.

That line of code would look like:

    Cells.MergeCells = False

 

[Defumator]

now my macro is working fine! i didn't know that this code existed!
Thank you very much!

 

[Joe4]

Your welcome!

Actually, you can also get that code by using the Macro Recorder (highlight your whole sheet, select Format, and uncheck the Merge Cells box). I just cleaned it up a little (as the Macro Recorder often takes about 10 lines to do what can be written in 1 line).

Works fine either way though!

 

[mstng50l]

I am having a similar problem but using the "unmerge" code makes the excel page unreadable. Do you have any other suggestions? Thank you!!

 

[Joe4]

I am having a similar problem but using the "unmerge" code makes the excel page unreadable. Do you have any other suggestions?

Did you then use "Center Across Selection" on each one to fix it up after unmerging, like was discussed above?