×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.