Re: Excel problem

On 27-Jun-09, at 1:00 PM, pctech-request@xxxxxxxxxxxx wrote:

Are you using VBA in Excel? Almost have to be. Anyhow, there is a Cells
collection, I think, for various entities - including a Range - the
Cells collection is essentially a 2-dimension array, so you use numeric
row and column Cells(2,3) is the cell in row 2, column C.

That's what I've been forced to do Vern. I was hoping there was a way to avoid it as I've never used it before and had no desire to learn. I haven't used the range notion (had trouble finding simple examples) but was able to iterate through the sheet simply with a For loop and direct cell references.

One thing made me laugh out loud though - everything else that works with Excel that I have seen (like the POI classes) has Column A as 0, B as 1 and so on. In VBA A is 1, B is 2, etc. That caused me a small debugging delay!

Thanks for the advice.



Jon Paris

www.Partner400.com
www.SystemiDeveloper.com