Adam,

I am confused. You mention G4, but it is nowhere in the code.And what do you
mean by '... and then for rng to be included..'? Do you mean the text rng,
the address of range, the contents of range, or what?

--
HTH

-------

Bob Phillips
"Adam" wrote in message
...
I want a cell to equal the contents of another cell and then there to be a
little text after. For example, I want a cell to equal the contents of G4
and then for mg to be included in the cell after the value of what's in
G4.
This is what I have and it isn't working.

wks_C.Range("A" & c).Value = "wks_S.Range("B" & s).Value mg"
or I tried
wks_C.Range("A" & c).Value = wks_S.Range("B" & s).Value mg

Thank you