Simple Concatenation
with worksheets("sheet1")
csz = .Range("C17").value & .Range("D17").value & .Range("E17").value
end with
I like to specify the property I want to use, too. But maybe you'd want
..text???
PJ wrote:
I want to concatenate the text from cells C, D & E17 into my csz variable.
What I have below works, but do I have to specify the sheet name for each
cell reference or is there a way to shorten this?
csz = Sheets("Sheet1").Range("C17") & Sheets("Sheet1").Range("D17") &
Sheets("Sheet1").Range("E17")
Thanks
--
Dave Peterson
|