Count from cell b71 to last cell
 

I cant seem to get it. I need to go to cell b71 count to last active cell
then add one so that i can add in totals.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200708/1

Count from cell b71 to last cell
 

Cells(Rows.Count,"B").End(xlUp).Offset(1,0).Select

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"jln via OfficeKB.com" <u25956@uwe wrote in message
news:7778376fb00db@uwe...
I cant seem to get it. I need to go to cell b71 count to last active cell
then add one so that i can add in totals.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200708/1