Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a function that would loop through all the cells in the used range of a single sheet and convert any merged cells to "xlCenterAcrossSelection" for the same range as the cells that were originally merged
For example, if the range "B2:J2" was merged, convert range "B2:J2" to centered across the selection My code (below) unmerges the cells but then fails to convert them to "center across" Dim rngCell As Rang For Each rngCell In ActiveSheet.UsedRang If rngCell.MergeCells = True The Selection.UnMerg Selection.HorizontalAlignment = xlCenterAcrossSelection <this line fails without any error End I Next rngCel Could someone please correct my code and/or show me example code that would accomplish what I'm trying to do TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |