Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use For loop to pick different Range of cells to Select & Merge?
Hi!
I'm trying to loop through Ranges of Cells to select & merge them together. I can do this by hand, and I can do this if I hardcode the cell row&column values. BUT, I can't seem to figure out how to do this programatically! Thanks! David -----------------sample code-------------------- For datastartrow = 5 to 50 rem datastartrow is the row I'm on ActiveSheet.Range("B13:H13").Select ActiveSheet.Range("B13:H13").Merge rem == Hardcoding works, but... I need to loop through the rows.... rem == HOW DO I CHANGE this to something I can loop through? rem == eg. this doesn't work for some reason: rem == ActiveSheet.Range(Cells(datastartrow, 2), Cells(datastartrow, 9)).Select rem == ActiveSheet.Range(Cells(datastartrow, 2), Cells(datastartrow, 9)).Merge With Selection .HorizontalAlignment = xlGeneral .VerticalAlignment = xlCenter .WrapText = True .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext End With Next i |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use For loop to pick different Range of cells to Select & Merge?
activesheet.cells(myrow,"B").resize(1,7).merge
Thanks for the quick answer! That helped me after days of searching for an answer!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use For loop to pick different Range of cells to Select &Merge?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i pick up a list of invoice numbers on a range of cells | Excel Discussion (Misc queries) | |||
loop through cells in a range and pick up corresponding cell values in another range | Excel Programming | |||
Specifying Range.Select in a loop | Excel Programming | |||
A loop to merge cells based on a value | Excel Programming | |||
How do I Pick a cell with highest value from a range of cells? | Excel Worksheet Functions |