Thread: Range Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Gerstman David Gerstman is offline
external usenet poster
 
Posts: 57
Default 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?