Yes, you must first select the sheet, then the cell. You can do
it on one line of code with Application.Goto. E.g.,

Application.Goto Rng


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Steven Drenker" wrote in
message
...
in article , Chip Pearson
at
wrote on 1/23/06 10:51 AM:

You set rng to Sheet1!A1:A10, but then you select a Chart
sheet.
You can't select a cell that is not on the active sheet.

Thanks, Chip. So I need to do it in two steps? First select the
sheet and
then select the cell? I can't combine into one step such as
ws.range.select?