Another one..
Assume cells e1,f1,g1 are merged (as are e2,f2,g2) up to e100
Same thing with cells in columns i,j,k
Cells in the inbetween columns are NOT merged.

I want to create a macro to size column width to 15 (each) of merged
cells in column e,f,g.
If I manually select the column in excel, I can do it.(ie click on the
column letter)
If I try to write basic VB to do (see below) it expands my column
selection to the entire data iin the sheet(cols a - k) and then applies
the column width to all of these columns (which I dont want)
Unfortunately I cant unmerge the cols

Any ideas???

Basic VB im using:

Columns("E:G").Select
Selection.ColumnWidth = 15


*** Sent via Developersdex http://www.developersdex.com ***