Hi,

I have a vba function that outputs data like this:

A B C D.....................................................................IV.............
TaskName StartTime Used NotUsed Used NotUsed Used NotUsed Used NotUsed ...
1 10 5 8 10 6 5 2 1 5
2
...
This data is used to create a task schedule chart - much like a gantt chart.

The problem I have is that my data set is too large, so for example the row for Task1 extends past the IV'th allowed column in Excel because task1 is scheduled several times - this results in a run time error problem because the vba func. outputs past the spreadsheet's range.

Are there any suggestions on how to get around the spreadsheet constraint?