Getting a range in an Excel Spreadsheet

[rewdee]

Hi All -- Please Help me before I give up and become a garbage collector.

I'm trying to create a graph in an Excel worksheet. I know how to export data and use Range as:

..blah.blah.Range("a1").CurrentRegion

but I only want to graph data in ColumnB to the end of data in the Excel spreadsheet so it would be something like:

..blah.blah.Range("B1..B?)

I will be your devoted fan if someone can help me here.

Thanks
Rewdee

Bonus Points: How do I get the graph to use the first column as my y-axis?