GET ROW COUNT

[100dtl]

Hi

Not sure if this is corect forum but here goes, I 'm trying to get the row number from a worksheet with vb at a given title

Ie;; At row 100 I have some text called 'End Row' I then want to get the row number this text s on, is this possible?

 

[Loomah]

Hi
In the example you give is the data on row 100?
Will there be more than one occurance of "End Row"?

Assuming no this will return the first row that contains "End Row"

Cells.Find("bill", [a1], , xlWhole, xlByRows, xlNext).Row

If you want the last row to cantain "End Row" then amend xlNext to xlPrevious.

If this isn't waht you're looking for I think (at least for me) you'll need to supply a little more detail.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[100dtl]

What is this [a1]?

 

[100dtl]

its ok, i know now