Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hilite merged cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hilite merged cells
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Errors in COUNT, COUNTA, COUNTIF when counting merged cells | Excel Worksheet Functions | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
Linking Merged Cells | Excel Worksheet Functions | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) |