-
May 9th, 2022, 12:35 PM
#1
Thread Starter
Fanatic Member
[RESOLVED] Get chart datarange
I have a line chart.
I can run this code either as macro or within VB6
Code:
ActiveChart.SeriesCollection(1).Select ActiveChart.SetSourceData Source:=Sheets("Activity").Range( _
"A5:A1102,L5:L1102"), PlotBy:=xlColumns
This is the result of changing the previous to 1102 manually in the 'record new macro' tab of Excel.
I need to run some code that can tell me the 1102 (or the value that is there before I upgrde it the 1102.
I hope that I am clear.
Thanks
-
May 9th, 2022, 04:20 PM
#2
Re: Get chart datarange
Do you want to run it in a macro, or in VB6?
My usual boring signature: Nothing
-
May 9th, 2022, 04:36 PM
#3
Thread Starter
Fanatic Member
-
May 9th, 2022, 04:51 PM
#4
Re: Get chart datarange
How does that make a difference? Same Excel Object Model fiddling either way. The answer will be found by studying the Excel documentation, not VB6.
-
May 10th, 2022, 08:31 AM
#5
Re: Get chart datarange
Moderator Action: Moved to office development.
-
May 11th, 2022, 02:22 AM
#6
Re: Get chart datarange
So basically, you want to find the Last Row in Excel using VBA? *hint hint hint*
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
-
May 12th, 2022, 09:43 AM
#7
Thread Starter
Fanatic Member
Re: Get chart datarange
Thank you Dilettante for you inspiration. I go the solution from the MrExcel forum.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|