Formula or function related to counting columns
Posted by Todd Kasenberg on July 18, 2001 11:11 AM
I have developed a Gannt chart worksheet that, due to the nature of the projects, has variable start and stop dates, and therefore, variable project durations.
This poses problems for me,because I wish to print the Gannt chart, but only the area of the chart that has data in it. In other words, I only need to print to the last shaded cell.
I can compute how many day-by-day cells there are in the Gantt chart - that is easy. But how do I tell Excel, in selecting the range, to move over X number of columns, and print only to there, and not beyond?