Excel copy to end of range

[richand1]

I've been looking all morning for a post that can help me with this, but have been unsuccessful.

I need some code to copy either a formula, a vlookup or just the contents of a cell, all the way to the end of a range or table.

There must be a post here from someone else asking this question! Can anyone help please?

Thanks
Rich

 

[PHV]

What have you tried so far and where in your code are you stuck ?
Which keywords did you use for your search ?
You may try:
PasteSpecial
End(xlDown)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886