tlukareski
New Member
- Joined
- Apr 11, 2002
- Messages
- 3
Hello-
I have a simple task that I need help with...
I have a spreadsheet which imports data from a text file. The data can change, meaning that it can have 10 rows one day, perhaps 20 the other. I can calculate the number of rows using the following line of code...
RowCount = WorksheetFunction.CountA(.Columns(1))
Now I need to set the range for a chart based on the number of rows using SetSourceData.
The range will always start at cell A1, how do I tell Excel to add the number from RowCount to the range for SetSourceData?
Thanks-
Thomas
I have a simple task that I need help with...
I have a spreadsheet which imports data from a text file. The data can change, meaning that it can have 10 rows one day, perhaps 20 the other. I can calculate the number of rows using the following line of code...
RowCount = WorksheetFunction.CountA(.Columns(1))
Now I need to set the range for a chart based on the number of rows using SetSourceData.
The range will always start at cell A1, how do I tell Excel to add the number from RowCount to the range for SetSourceData?
Thanks-
Thomas