| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Loop Problem
Hi! I have a set of data (Range A1:C5750) where some cells in column A contain the text "work ctr". at each of these cells I need to perform several steps (starting at that cell) and then go on to the next cell that contains "work ctr". and do the exact same thing. The data is several thousand rows long and column A contains cells with numbers, dates, text and blanks (data is not continuous). I think this would be a loop thing but I'm not experienced with them so I'm not sure what method would be best. Any help or direction would be great! THANKS!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=542167 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
For Loop Problem
Look at Find and Findnext in VBA help.
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "Brian Matlack" wrote in message news:Brian.Matlack.27ux3a_1147710004.9878@excelfor um-nospam.com... Hi! I have a set of data (Range A1:C5750) where some cells in column A contain the text "work ctr". at each of these cells I need to perform several steps (starting at that cell) and then go on to the next cell that contains "work ctr". and do the exact same thing. The data is several thousand rows long and column A contains cells with numbers, dates, text and blanks (data is not continuous). I think this would be a loop thing but I'm not experienced with them so I'm not sure what method would be best. Any help or direction would be great! THANKS!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=542167 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
For Loop Problem
Thanks Bob! I guess I was making it too hard -- Brian Matlac ----------------------------------------------------------------------- Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350 View this thread: http://www.excelforum.com/showthread.php?threadid=54216 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop Problem | Excel Programming | |||
| Loop Problem | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
| VBA Loop Problem | Excel Programming | |||
| loop problem | Excel Programming | |||
![Brian Matlack[_75_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
