sobeitjedi
Board Regular
- Joined
- Mar 13, 2006
- Messages
- 235
- Office Version
- 365
Hi.
I have data in columns A&B which I want to use to build a graph using a macro. At the moment, to select the data I want to use, I use:
Columns("A:B").Select
This works when building the graph step-by-step - it uses only the data in columns A&B as far as the rows go down. The row count will vary in length each time I run it.
The problem is, when I run the macro, it doesn't work - it's selecting all columns A&B, not just where data is available.
So my question is, how do I select all data, where it is available, in A&B in macro code?
I have data in columns A&B which I want to use to build a graph using a macro. At the moment, to select the data I want to use, I use:
Columns("A:B").Select
This works when building the graph step-by-step - it uses only the data in columns A&B as far as the rows go down. The row count will vary in length each time I run it.
The problem is, when I run the macro, it doesn't work - it's selecting all columns A&B, not just where data is available.
So my question is, how do I select all data, where it is available, in A&B in macro code?