How do I count Columns on a Sheet

[indigomage]

How do I count the number of columns on a Sheet?

I can get the count of the number of sheets, but how do I get this for Columns
I tried LastCol, but that always returns 0.


regards

Ian

[larsa]

Hello

Use XLS[Sheet].CalcDimensions before you use LastCol (or FirstRow,FirstCol,FirstRow).

CalcDimensions is not called automatically because it takes some time to calculate it.

[indigomage]

Thanks, will give that a go!