Count from cell b71 to last cell

's Computer Specifications

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

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
subtract one cell from each cell in a range and count instances	tworrall	Microsoft Excel Worksheet Functions	2	15th Oct 2009 05:31 PM
Re: How to auto count data in an empty cell to be 0. Blank cell=0	Dave Peterson	Microsoft Excel Misc	4	13th Dec 2006 08:17 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ?	Markus Obermayer	Microsoft Excel Programming	2	4th Jan 2005 08:01 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ?	Markus Obermayer	Microsoft Excel Misc	1	4th Jan 2005 08:01 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ?	Markus Obermayer	Microsoft Excel Worksheet Functions	1	4th Jan 2005 08:01 PM