sobeitjedi
Board Regular
- Joined
- Mar 13, 2006
- Messages
- 235
- Office Version
- 365
Hi.
I have data in Columns A & B, starting at row 15. I want to use a macro to build a graph, but the number of rows used will vary. How do I do this?
For example, at the moment rows 15 to 41 has the data in columns A&B for my graph. Row 42 onwards is blank. But the next time I import data, it could be 15 to 104 (105 onwards will be blank) in A&B.
Can you please help?
I have data in Columns A & B, starting at row 15. I want to use a macro to build a graph, but the number of rows used will vary. How do I do this?
For example, at the moment rows 15 to 41 has the data in columns A&B for my graph. Row 42 onwards is blank. But the next time I import data, it could be 15 to 104 (105 onwards will be blank) in A&B.
Can you please help?