please help with fill or paste to "Last Row"

[jbaich]

Nevermind, figured it out!

Hi all, i have been reading posts and threads on this topic all morning and form some reason, can't seem to get any of the already posted solutions to work. Likely this is because i have only a very limited understanding of VBA and its syntax, so when i try something i'm neglection to include a piece of code or something that everyone else would automatically know to include. Anyway, here's what i'm trying to do...

Insert column (now Col A), apply formula =concatenate(B2,C2,D2,) in A2 and fill down to the last row. Column B has data all the way down so i've been trying to use variations of...

Range("B2").Select
    Selection.End(xlDown).Select
    Range("A256").Select
    Range(Selection, Selection.End(xlUp)).Select
    ActiveSheet.Paste

Obviously line 3 'Range("A256").Select' is not what i want, this is where i want it to move over from col B to Col A so that i can past up regardless of how many rows are in the table tomorrow or the next day... This piece of code is in the middle of a larger macro, and i'm basically building this using the recorder and a couple of books i have, but i really have no understanding of syntax... I realize this question has been asked a lot, i don't know why i cant get some of the other solutions people have posted to work.

as always, any help is much appreciated!
joe