Hilite merged cells

D

Dave

Hi,
Does anyone out there know how to modify Chip Pearson's (excellent)
Hilite code so that it will work in merged columns D-M to highlight the
active cell but then not affect any other columns when the acctive cell
is outside thos columns?

TIA,

Dave
 
J

Jim Cone

Dave,
I would say that most experienced programmers avoid using merged cells.
They became experienced by using merged cells.
"Center Across Selection" does the same as merging in most cases...
Worksheets(2).Range("D1:M100").HorizontalAlignment = xlCenterAcrossSelection
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Dave" <[email protected]>
wrote in message
Hi,
Does anyone out there know how to modify Chip Pearson's (excellent)
Hilite code so that it will work in merged columns D-M to highlight the
active cell but then not affect any other columns when the acctive cell
is outside thos columns?
TIA,
Dave
 
Top