Just to add that count counts only cells with numbers. countA might be
better.

Also Tad probably meant

set a = worksheets("Sheet1")

--
regards,
Tom Ogilvy

"tad_wegner" wrote
in message ...

dave-

count = Application.WorksheetFunction.count(Range(Cells(9, 15),
Cells(18, 15)))
Cells(9 + count, 15) = "insert your 'output' data"

you didnt add any specifics so my answer is a little vague, sorry.
when using the "cells" identifier... cells(row, column).

typically, (and this is just me) i code these lines slightly
differently. when you use "range" or "cells" it is public and works on
any worksheet, whichever one is active. if you want it to only work on
a specific worksheet you might want to do this...

a = worksheets("sheet1")

..after doing so you can do this...

a.range(a.cells(9,15), a.cells(18,15))
a.cells(9 + count, 15) = "insert your 'output' data"

..this only works on worksheet("sheet1") now so you can have any
worksheet active.

hope this helps, and isnt too confusing.
-tad


--
tad_wegner
------------------------------------------------------------------------
tad_wegner's Profile:
http://www.excelforum.com/member.php...o&userid=27770
View this thread: http://www.excelforum.com/showthread...hreadid=474745