Error on Set Rng statement?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve <steve_andruszka@xxxxxxxxx>
Date: Tue, 4 Mar 2008 15:15:32 -0800 (PST)

Hi all. Any idea why this line errors out if the *** Data is not
the active ***? If I run the code while on the Data ***, all
works well. If I run thwe code while on any other ***, I get an
"application defined or object defined error". Thanks!

Set rng = Worksheets("Data").Range(Cells(1, 1), Cells(Rows.Count,
1).End(xlUp))
.

Follow-Ups:
- Re: Error on Set Rng statement?
  - From: Dave Peterson

Prev by Date: Re: Loop macro error
Next by Date: RE: Find value in a 2nd workbook
Previous by thread: Using Array's
Next by thread: Re: Error on Set Rng statement?
Index(es):
- Date
- Thread