Adam

Your second line is very close. You need to tell the system you want to
concatenate the the string "mg" to the end of the value.

wks_c.Range("A" & c).Value = wks_s.Range("B" & s).Value & "mg"

Stan Shoemaker
Palo Alto, CA

"Adam" wrote:

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