Hello
I am trying to write a macro to insert an up arrow into a range of cells whilst retaining the existing text.
I have managed to write something that inserts text but am struggling to insert an arrow. Here's the line:
Can anyone show me how to tweak the code to do this?
Thank you
I am trying to write a macro to insert an up arrow into a range of cells whilst retaining the existing text.
I have managed to write something that inserts text but am struggling to insert an arrow. Here's the line:
VBA Code:
If Sheets(cel.Text).Range("I47") <= Sheets(cel.Text).Range("I44") * 1.05 Or Sheets(cel.Text).Range("J47") <= Sheets(cel.Text).Range("J44") * 1.05 Then cel.Value = cel.Value & " U"
Can anyone show me how to tweak the code to do this?
Thank you