don't calculate row using macro and move to next row if specified cell is empty

[IrishMist1748]

The following macro does well at concatenating 2 constant values and the values in columns A and CF and places it in the CP field. What I need to know is is it possible to modify this code so if there is NOT a CF field cell value (that is it is blank) that the formula does not run and moves on to the next row? That is, the CP1 cell remains blank?

Range("CP1:CP" & Cells(Rows.Count, "A").End(xlUp).Row).Formula = "=""Handler_x-""&A1&""_y-600_z-""&CF1&"".jpg"""

[judgeh59]

do you already have the looping part done?....check out IF statement and ISBLANK() function and the NOT function....