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?

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?