LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 126
Default trouble with selecting ActiveSheet.Shapes.Range

I'm going nuts (again).

At the end of a routine I'm trying to select a group of embedded
charts.
According to the online help in excel 2007, the following ought to
work:

ReDim chtnames(1 to 2)
set the two chtnames
ActiveSheet.Shapes.Range(chtnames).Select

In fact, the above did work for me when I first put it in. But now...
The above generates an "the index into the specified collection is out
of bounds" run time error.

However, the following will work in the immediate window where the
above fails.
activesheet.shapes.range(array(chtnames(1),chtname s(2))).select

What am I missing?

Thanks,

Brian
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble Selecting a Range in VBA MJatAflac Excel Programming 5 November 30th 09 04:58 PM
ActiveSheet.Shapes macro [email protected] Excel Programming 3 October 22nd 07 10:31 PM
selecting ActiveSheet.UsedRange Gary''s Student Excel Programming 5 May 12th 06 04:29 PM
ActiveSheet.Shapes ole_ Excel Programming 1 April 26th 05 02:34 PM
Shapes In ActiveSheet Tommi[_2_] Excel Programming 5 December 2nd 03 02:02 PM


All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"