| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Going loopy on a loop
hi folks
Im looping thru a range to find the first blank cell to fill... of exiting my loop how do I paste into it? Range("B4").Select Selection.Copy For Each c In Worksheets("admit").Range("B11:B32").Cells If c.Value = 0 Then Exit For Next ' past data here how do I past into c.? - the first cell containing 0 that Ive found... thanks folks Images of home (NZ) http://www.titahi-bay.co.nz/home What we are up to in the UK http://www.titahi-bay.co.nz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loopy? | Excel Worksheet Functions | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
| Loopy Code | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
| HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Threaded Mode
