I bet that the activecell isn't what you think it should be.

Maybe adding:
msgbox activecell.address(external:=true)
to your code will help you debug the problem.

Maxi wrote:

Hi!

I have first name in A1 and last name in A2

When I use the syntax
Sheets("Extract").Range("A" & ERow).Value = ActiveCell.Offset(0,
-2).Value & ActiveCell.Offset(0, -3).Value

Value of ERow is 1
Offset -2 is the first name
Offset -3 is the last name

VBA does not support "&" to get both the names in one cell of a
different sheet?

Please help

--

Dave Peterson