View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gummy Gummy is offline
external usenet poster
 
Posts: 5
Default Possible to select a range of cells from a Shape Object

Hello,

I was wondering if it is possible to draw a rectangle on the screen, then
determine all the cells that the rectangle is over?

I know the opposite can be done. Jon Peltier has posted code where you
select a range and then the chart resizes to that range. His code can be
found he
http://peltiertech.com/Excel/Charts/...tCreation.html

Thanks for the help.

-Rob