Thread: Going loopy on a loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John in Surrey John in Surrey is offline
external usenet poster
  
Posts: 6
Default 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
Reply With QuoteReply With Quote