LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 139
Default Discontinuous Range via VBA using R1C1?

Per Peter T:
Seems like a more direct approach would be for me to just pick apart the

larger
range cell-by-cell and grab what I need.


Why doesn't Jon's advice work for you.


Dunno - but the first thing that comes to mind is RCI on my part...


But that means that I'd need to store that range address somewhere in the
chart object.


Isn't the range defined and hence stored in the series formula(s)


Yes. But the range I need is different from the chart's. It's a superset
of the chart range from which I'd extract some rows/columns to place
below the chart.


Chart names are more restricted than shape names in terms of allowable
punctuation characters. Replace ":" in the formula with something,
underscore is good.


I tried a dash... but no go. I'll give the underscore a shot...

But now I'm re-thinking my whole strategy. This started because I'm creating
many chart objects in one process and arranging them in another process.

I think I need to combine the two processes so that I position/size each chart
when I create it. At that time I have access to the data I need so I should be
able to also place the supplemental data beneath the chart at that time.
--
PeteCresswell
 
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
Average range of discontinuous cells Nadine Excel Worksheet Functions 1 May 11th 10 07:14 PM
Range selection with R1C1 Adam1 Chicago Excel Discussion (Misc queries) 6 November 8th 07 04:02 PM
Using R1C1 in VB to select a range Robert_L_Ross Excel Programming 2 December 17th 05 07:45 AM
Select Range using R1C1 verizon Excel Programming 4 June 16th 04 01:11 PM
R1C1 to Range Jahson Excel Programming 3 February 17th 04 12:29 PM


All times are GMT +1. The time now is 07:27 AM.

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"