width of Merged cells within un merged cells

D

Darin Kramer

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 ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strip out certain rows that have merged cells 2
Fixing text wrap in merged cells 1
Code to sort rows getting hung up by merged cells 0
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
How do I sort a table w/ merged cells 3
Sharing workbooks limitations - Merged Cells 12
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2

Top