Thread: Range Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven Drenker[_4_] Steven Drenker[_4_] is offline
external usenet poster
  
Posts: 4
Default Range Problem
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?

Reply With QuoteReply With Quote