Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
traverse until non integer
here is the problem I have. I'm trying to condition format a fe different lines. As it stands now it will go across the spreadshee until a zero value is found, however I would like it to keep goin until it reaches a non integer value. for example: Jan Feb Mar Apr Jun Jul Aug Sep Oct Nov Dec YTD Calctype 25 50 21 96 cumulative so I would like the macro to check all the values until it reaches th word "cumulative -- evil bab ----------------------------------------------------------------------- evil baby's Profile: http://www.excelforum.com/member.php...fo&userid=3198 View this thread: http://www.excelforum.com/showthread.php?threadid=51784 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
traverse until non integer
rw = 1 ' set to row you want to traverse
i = 1 do while lcase(cells(rw,i) < "cumulative" i = i + 1 Loop another possibility set rng = cells(rw,"IV").End(xltoLeft) lastcol = rng.column -- Regards, Tom Ogilvy "evil baby" wrote in message ... here is the problem I have. I'm trying to condition format a few different lines. As it stands now it will go across the spreadsheet until a zero value is found, however I would like it to keep going until it reaches a non integer value. for example: Jan Feb Mar Apr Jun Jul Aug Sep Oct Nov Dec YTD Calctype 25 50 21 96 cumulative so I would like the macro to check all the values until it reaches the word "cumulative" -- evil baby ------------------------------------------------------------------------ evil baby's Profile: http://www.excelforum.com/member.php...o&userid=31983 View this thread: http://www.excelforum.com/showthread...hreadid=517844 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
survey traverse computations | Excel Discussion (Misc queries) | |||
How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
integer | Excel Worksheet Functions | |||
traverse data based on 2 conditions | Excel Discussion (Misc queries) | |||
Traverse treeview bottom to top | Excel Programming |