Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I write more condense code for the following?
I appreciate it. .Cells(iRow + 1, "A").Value = "" .Cells(iRow + 2, "A").Value = "" .Cells(iRow + 3, "A").Value = "" .Cells(iRow + 4, "A").Value = "" .Cells(iRow + 5, "A").Value = "" .Cells(iRow + 6, "A").Value = "" .Cells(iRow + 7, "A").Value = "" .Cells(iRow + 8, "A").Value = "" .Cells(iRow + 9, "A").Value = "" .Cells(iRow + 10, "A").Value = "" .Cells(iRow + 11, "A").Value = "" .Cells(iRow + 12, "A").Value = "" .Cells(iRow + 13, "A").Value = "" .Cells(iRow + 14, "A").Value = "" .Cells(iRow + 1, "B").Value = "" .Cells(iRow + 2, "B").Value = "" .Cells(iRow + 3, "B").Value = "" .Cells(iRow + 4, "B").Value = "" .Cells(iRow + 5, "B").Value = "" .Cells(iRow + 6, "B").Value = "" .Cells(iRow + 7, "B").Value = "" .Cells(iRow + 8, "B").Value = "" .Cells(iRow + 9, "B").Value = "" .Cells(iRow + 10, "B").Value = "" .Cells(iRow + 11, "B").Value = "" .Cells(iRow + 12, "B").Value = "" .Cells(iRow + 13, "B").Value = "" .Cells(iRow + 14, "B").Value = "" .Cells(iRow + 1, "G").Value = "" .Cells(iRow + 2, "G").Value = "" .Cells(iRow + 3, "G").Value = "" .Cells(iRow + 4, "G").Value = "" .Cells(iRow + 5, "G").Value = "" .Cells(iRow + 6, "G").Value = "" .Cells(iRow + 7, "G").Value = "" .Cells(iRow + 8, "G").Value = "" .Cells(iRow + 9, "G").Value = "" .Cells(iRow + 10, "G").Value = "" .Cells(iRow + 11, "G").Value = "" .Cells(iRow + 12, "G").Value = "" .Cells(iRow + 13, "G").Value = "" .Cells(iRow + 14, "G").Value = "" Faye Larson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help wanted with Code, Please | Excel Programming | |||
More efficient code | Excel Programming | |||
Help wanted with VBA code | Excel Programming | |||
Efficient Code | Excel Programming | |||
vba code wanted | Excel Programming |