Multiple column chart using lastrow - 1

Asked Jul 09 '19 at 15:14

Active Jul 09 '19 at 15:20

Viewed 34 times

My current sub uses the lastrow which includes the total in my data set, I want to use one above the lastrow so the chart doesn't include the "Total Row" but getting errors.

Ive tried to do range("A6",Range(LastRow)

Ive also tried Range("A6", Range("A6").End(xlDown)-1 )

Sub NewChart()
    Dim LastRow As Long
    LastRow = Worksheets("Dashboard").Cells(Rows.Count, "A").End(xlUp).Row - 1

    Worksheets("Dashboard").Select
    Union( _
    Range("A6", Range("A6").End(xlDown)), _
    Range("E6", Range("E6").End(xlDown))).Select
    Charts.Add 
End Sub

edited Jul 09 '19 at 15:20

Robert Todar

2,085
2
11
31

asked Jul 09 '19 at 15:14

CuriousGeorge

2

`Range("A6:E" & LastRow)`. And try to [avoid `Select`](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba). – BigBen Jul 09 '19 at 15:17
The range ("A6:E" & LastRow) will use data in columns B,C,D though. I only want columns A,D – CuriousGeorge Jul 09 '19 at 15:18
1

Then `Union(Range("A6:A" & LastRow), Range("E6:E" & LastRow))`. – BigBen Jul 09 '19 at 15:20

Multiple column chart using lastrow - 1

0 Answers0