J jln via OfficeKB.com Aug 30, 2007 #1 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.
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.
B Bob Phillips Aug 30, 2007 #2 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)
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)
