Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I am a new learner. I created the loop below with the
help of macro. Now I am wondering is there anyway to shorten this block of code - (also any statements that i can safely leave out?) Thank you. My question may sound foolish..I am grateful for your understanding and assistance. Tetsu Hara Dim row As Integer row = 11 Do While row < 157 row = row + 2 For col = 1 To 3 Range(Cells(row, col), Cells(row + 1, col)).Select With Selection .HorizontalAlignment = xlGeneral .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = True End With Next col Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell copy action pauses for 15 second for the smallest action | Excel Discussion (Misc queries) | |||
Perform action if value in cell - conditional VB stmt | Excel Discussion (Misc queries) | |||
Cell Formatting Advice:- Text displayed as .........####### | Excel Discussion (Misc queries) | |||
Excel VBA - Action if a cell holds a certain value? | Excel Programming | |||
Perform action when cell is clicked | Excel Programming |