Hello,

I'm having a bit of a problem in my macro with something that should be
very simple. Namely, I'm trying to select a column.

I need to insert a column at Column N. My script is as follows:


Columns("N:N").Select
Selection.Insert Shift:=xlToRight


The problem appears to be that I have a cell (which contains a title)
that is merged across several columns on my worksheet, in particular,
Range("N:S").

So, whenever my macro runs, it always selects the whole Range("N:S")
instead of just Column N. Does anyone know how I may work around this?
When I do this manually, I can select Column N alone and not the whole
range across which the topmost cell is merged.

Any ideas greatly appreciated!


-Paul



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/