About Us

glad it helped

--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Many many thanks Don........

A little tweaking to adapt to my particular environment and your code
flies
perfectly. It does just what I asked for....it's don't get much better
than
that.!

Thanks again,
Vaya con Dios,
Chuck, CABGx3

"Don Guillett" wrote:

let me know how it works out. Enjoy your "day off"

--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Thanks Don.......

I'm off today, car wouldn't start, then found I need to take my Lady
to
the
Doctor and one of the cats to the Vet, etc etc........but will try it
tomorrow at work for sure........

Many thanks,
Vaya con Dios,
Chuck, CABGx3

"Don Guillett" wrote in message
...
try

Sub dochart()
lastrow = Cells(Rows.Count, "aa").End(xlUp).Row
Set myrng = Range("AA9:AA" & lastrow & ",AE:AE" & lastrow)
Charts.Add
With ActiveChart
.ChartType = xlLineMarkers
.SetSourceData Source:=myrng, PlotBy:=xlColumns
.Location Whe=xlLocationAsObject, Name:="Reports"
End With
Range("aa9").Select
End Sub

--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Thank you kind Sir.............I don't know exactly what to do
with
it,
but
I will give it a go, or two or three <g.....

Vaya con Dios,
Chuck, CABGx3

"Don Guillett" wrote in message
...
this might help
lastrow=cells(rows.count,"aa").end(xlup).row
myrng=Range("AA9:AA" & lastrow&",Ae9:Ae" & lastrow)

--
Don Guillett
SalesAid Software

"CLR" wrote in message
...
Hi All......

I have code below, that after I autofilter and copy results
over
to
another
sheet, will go to AA9 and AE9 as the first cells in Series1
and
Series2
sources...that works fine, except I never know where the
bottom of
the
column
is going to be based on what data is filtered.....when I try
to
Record
the
macro, I only get fixed references....AA9 and AE9 are fine for
the
top
of
the
column, but I need somehow to "find" the bottom of the
column.......

Existing code:

Sub M034Chart()
'
' M034Chart Macro
' Macro recorded 04/12/2005 by CLR
'

'
Sheets("Reports").Select
Range("AA9:AA51,Ae9:Ae51").Select
Range("Ae9").Activate
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData
Source:=Sheets("Reports").Range( _
"AA9:AA51,Ae9:Ae51"), PlotBy:=xlColumns
ActiveChart.Location Whe=xlLocationAsObject,
Name:="Reports"
End Sub

Any help would be much appreciated....
Vaya con Dios,
Chuck, CABGx3

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Range for Function (Vlookup etc)	IshtiaqM	Excel Worksheet Functions	4	March 27th 05 09:47 PM
Dynamic series in Chart	Jeff	Charts and Charting in Excel	2	February 24th 05 11:54 AM
formula to set up dynamic range in names	Jeff	Excel Worksheet Functions	0	February 23rd 05 03:45 PM
Dynamic Print Range Help	waxwing	Excel Worksheet Functions	2	February 21st 05 03:47 PM
Add a Dynamic Range with 2 Conditions Q	John	Excel Worksheet Functions	7	December 23rd 04 02:58 PM

Menu

About Us