Can some one help me with a VBA Code

[mchapman123]

I found a code through the forum search that will allow you to define what text you want to insert in front of cells that are already populated. example
I have a column of picture names and I want to insert the url for each picture. so I used

Sub test()
With Range("t2", Range("t" & Rows.Count).End(xlUp))
.Value = Evaluate("if(" & .address & "<>"""",""www.abc123.com/v/vspfiles/photos/manufacturer/ ""&" & .address & ","""")")
End With
End Sub

and this puts the url infront of my picture names, so t2 that was 90009.jpg becomes www.abc123.com/v/vspfiles/photos/manufacturer/90009.jpg

but what would be the reversal of this allowing me to put text behind the text that are already in the cells.

I am new to this and do not understand what in the code determines whether the text will insert infront or behind the data already in the cell. Thanks !!

 

[MickG]

Try this:- One for "Before " and One for "After".

With Range("A1", Range("A" & Rows.Count).End(xlUp))
.Value = Evaluate("if(row(), ""Before Cell Value /"" & " & .Address & ")")
End With

With Range("A1", Range("A" & Rows.Count).End(xlUp))
.Value = Evaluate("if(row(), " & .Address & " & ""/After cell Value"" " & ")")
End With

Mick