Hi all,

I have a question. I am currently working on a excel project. The excel doc has 2 columns (last name (column A) and first name (column B)). every month i would create a CONCATENATE formula in column C to combine first name and last name to make up full name..

Then I would autofill the formula down to the last row of data.. i would like to automate this process with macro so I've been playing around with it for some time but the code does not seem to be working properly.

The issue im having is with regards to the autofill. I need a macro that would automatically fill the concatenate formulas down to the LAST ROW OF DATA! the code im having now is until row 9219. but the number of rows vary by month.. thus i want to have a macro that would automatically fill until last row of data..

Thanks for the help!

Sub GL_String_Import_Access()
'
' GL_String_Import_Access Macro
'
' Keyboard Shortcut: Ctrl+g
'
Columns("C:C").Select
    Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    Range("C1").Select
    ActiveCell.FormulaR1C1 = "Full Name"
    Range("C2").Select
    ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-1],"" "",RC[-2])"
    Selection.AutoFill Destination:=Range("C2:C9219")
    Range("C2:C9219").Select
End Sub