Re: Excel problem

Jon,
Have you resolved this now?

Cheers,


Norm Dennis

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of Jon Paris
Sent: Sunday, 28 June 2009 3:34 AM
To: pctech@xxxxxxxxxxxx
Subject: Re: [PCTECH] 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