Thread
:
Going loopy on a loop
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Going loopy on a loop
No loop required. Try this
Sub fillfirstblankinrange()
With Worksheets("sheet2")
..Range("b4").Copy .Range(.Range("b11:b32").Find("").Address)
End With
End Sub
--
Don Guillett
SalesAid Software
"John in Surrey" wrote in message
...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]