Populating multiple graphs in Excel VBA

Question

I have an Excel macro that populates a graph from .csv files, with values starting from cells A1, B1 in x and y axes. Now when I add multiple .csv files with values ranging from A3, B3, it throws an error saying the cells are empty. Any idea why this happens?

The following folder has a macro file and two .csv files, the macro works if one of the files is deleted.. — user1270123
– user1270123, Commented May 10, 2012 at 16:45
Which line is giving you the error? I got an error on a different line which was expected but I am not getting the error that you have mentioned above. — Siddharth Rout
– Siddharth Rout, Commented May 10, 2012 at 16:54
this line Plot_y = .Range("B1",Selection.End(xlDown)).Rows.Count — user1270123
– user1270123, Commented May 10, 2012 at 17:08

Siddharth Rout · Accepted Answer · 2012-05-10 17:21:20Z

2

Change the lines

Plot_y = Range("C1", Selection.End(xlDown)).Rows.Count
Plot_x = Range("D1", Selection.End(xlDown)).Rows.Count

to

Plot_y = Range("C" & Rows.Count).End(xlUp).Row
Plot_x = Range("D" & Rows.Count).End(xlUp).Row

And try again.

edited May 10, 2012 at 17:21

answered May 10, 2012 at 17:10

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1270123 Over a year ago

I get an error called "invalid or unqualified reference" after making this change in the very same lines

Siddharth Rout Over a year ago

sorry my mistake, I had directly typed it here. Remove the dots before .Rows updating my post above

Collectives™ on Stack Overflow

Populating multiple graphs in Excel VBA

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related