Good morning all,
I posted on here last week regarding a loop I've been working with and we touched upon the topic of iterating 'backwards', as it were, through the range. The loop I've been working with looks like this:
I've now found a scenario where it really would be useful to be able to iterate through each cell from the bottom of the range to the top of the range. I've tried reversing the range, so that it is specified as D1000 : D8, but this makes no difference.
Thanks in advance for any help you can offer,
Matthew
I posted on here last week regarding a loop I've been working with and we touched upon the topic of iterating 'backwards', as it were, through the range. The loop I've been working with looks like this:
Code:
Dim rnArea As Range
Dim rnCell As Range
Set rnArea = Range("D8:D1000")
For Each rnCell In rnArea
With rnCell
'Commands will go here
End With
Next
Thanks in advance for any help you can offer,
Matthew