there's a part in my code that scans for
the strings in the cells of my worksheet.

this would look like this:

VB Code:
  1. Do
  2.  
  3. '.... blah blah
  4.  
  5. Text1.Text = .Cells(i, j)
  6.  
  7. '.... blah blah
  8.  
  9. Loop

what I want to know:

how can I get the cell count or name or
whatever that is:

e.g. "A13" or "B16"

any ideas?

thx!