Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping through range
I have a range withing a list, i wish to loop throught the range
without activating the cells and in each blank cell put todays date in. I am using a do loop but I am struggling, possible need a for loop but I am not to good on these, any advice much grateful John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping through range
Hi,
There are several ways of which this one may meet your needs Sub versive() Set myrange = Range("A1:A10") 'Change to suit For Each c In myrange If IsEmpty(c) Then c.Value = Date End If Next End Sub Mike " wrote: I have a range withing a list, i wish to loop throught the range without activating the cells and in each blank cell put todays date in. I am using a do loop but I am struggling, possible need a for loop but I am not to good on these, any advice much grateful John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Range Based On Certain Criteria? Possible looping through the Range | Excel Programming | |||
Determine if range has NO Blank Cells without looping through each cell in range | Excel Programming | |||
Looping Range | Excel Programming | |||
Looping in a range | Excel Programming | |||
Looping through a range | Excel Programming |