I am making a macro to copy data from a cell in one workbook and pasting it into another workbook. Unfortunatly I don't know VB too well, I'm more use to writing formulas in excel cells.

I'm trying to write an IF, THEN, ELSE statement in which the program will not display a cells contents if there is nothing to display (blank cell). I do most of my programs in excel rather than VB. This is what I would put in excel to do what im looking to do: If(A1="","",A1). How do I go about doing that in VB? Here is what I have so far, I'm just working around it by telling the program to display the results in a different cell, but its not working as planned, and I need the program to just not display the info anywhere.

Dim NTHNG As String
Dim TFR1 As String

NTHNG = Range("GL19").Value
TFL1 = Range("BK12").Value

If TFL1 = "" Then .Cells(3, 115).Value = NTHNG Else .Cells(12, 63).Value = TFL1

Any help would be appreciated

Dan