Macro to create pivot table/ chart

S

Saint

I've been looking to find a way to make macro that will take a set o
data and create a chart for me. The pivot table only takes a few row
of data and then sorts it into Top 15. Is there some sort of referenc
I can look at for help with this
 
G

Guest

Try recording a macro that creates a table. Then go back and change the range.
It usually will be in a R1C1 format.
You can create a variable that stores the last row like

Dim Lrow as integer, MyRange as string

Lrow = sheets(1).range("A65000")end(xlup).row

MyRange = "A5:H" & Lrow

then substitute the R1C1 in the code with range(MyRange)
[email protected]
 
J

Jon Peltier

Even better, use something like
Range("A1").CurrentRegion.Address(xlReferenceStyle:=xlR1C1)
or
ActiveSheet.UsedRange.Address(xlReferenceStyle:=xlR1C1)
This makes it much easier than keeping track of the size of the data range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top