Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any easier way than looping on ranges
Hi,
My problem goes like this. I have 5 tables within a sheet. Each table consist of variable no of columns where recordsar inputted. Each table is separated from another tables by a variable no of column with "blank" records. Is there any way I can improve on the following code (I find it to slow)? StartC1 = m Do '<expression1...... StartC1 = StartC1 + 1 Loop Until Cells(Rowi, StartC1).Value = Empty StartC2 = StartC1 Do '<expression1...... StartC2 = StartC2 + 1 Loop Until Cells(501, StartC2).Value < Empty StartC3 = StartC2 Do '<expression1...... StartC3 = StartC3 + 1 Loop Until Cells(501, StartC3).Value = Empty etc.... StartC2 = StartC2 - 1 More Power!!! BR, Billabon -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any easier way than looping on ranges
Selection.End(xlToRight).Select
will do what Ctrl+RightArrow does. It should speed it up spectacularly. HTH, Nikos "Billabong " wrote in message ... Hi, My problem goes like this. I have 5 tables within a sheet. Each table consist of variable no of columns where recordsare inputted. Each table is separated from another tables by a variable no of columns with "blank" records. Is there any way I can improve on the following code (I find it too slow)? StartC1 = m Do '<expression1...... StartC1 = StartC1 + 1 Loop Until Cells(Rowi, StartC1).Value = Empty StartC2 = StartC1 Do '<expression1...... StartC2 = StartC2 + 1 Loop Until Cells(501, StartC2).Value < Empty StartC3 = StartC2 Do '<expression1...... StartC3 = StartC3 + 1 Loop Until Cells(501, StartC3).Value = Empty etc.... StartC2 = StartC2 - 1 More Power!!! BR, Billabong --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOPING multiple ranges | Excel Discussion (Misc queries) | |||
looping through ranges: how to speed up? | Excel Programming | |||
Is there an easier way to address ranges?? | Excel Programming | |||
Looping through Ranges of Rows | Excel Programming | |||
Looping through Ranges of Rows | Excel Programming |