Range Error
I would like to scroll through a column of entries.
So I set up a range:
Dim av_range As Range
Set av_range = Worksheets(1).Range("A2").End(xlDown)
However when I get to the next line
For Each c In Range("av_range")
I get the following error:
Runtime error 1004
Application defined or object-defined error
What exactly am I doing wrong?
|