Thread
:
VBA - entering a formula in excel
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
VBA - entering a formula in excel
perhaps
lastrow=cells(rows.count,"a").end(xlup).row
or
lastrow=cells(activecell.row,activecell.column).en d(xlup).row
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Marie" wrote in message
...
I want to be able to enter a formula into the spreadsheet which counts the
number of entries in a range.
However the range can be a variable number of rows.
It will however always refer to the row which is end(xlup) from the cell
containing the formula (ie my start point - the activecell) and it will
always anchoring from this pount to end(xlup) twice then down one cell. So
basically i am wanting to enter a number of formulas in various parts of
the
spreadsheet which are never in the same location
-counta(End(xlup):(End(xlup)end(xlup)(down)) are my key strokes - but can
not
see how to replicate this in VBA
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett