Well, till someone else comes along, that's not really how they do it to my
knowledge. What they do is use xlUp. Just do a google search for it, and
you'll find lots of samples.
************
Anne Troy
www.OfficeArticles.com

"dutchinny" wrote in message
...
cell named 'gohere' contains a cell reference created by concatenation:
="$A$"&D15
(where d15 contains the count of non-blank cells.) so i end up with e.g.
$a$7. my question is how to reference the cell named 'gohere' in a macro
that will place me in $a$7. i'm only a beginning macro-ist with no vb
experience......

my ultimate purpose is to paste content from sheet 1 to the next available
cell in sheet 2

i've tried to apply similar scenarios that i found on the forum to my
situation but haven't been very successful.

thank you for any advice.