Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Concatenation
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple concatenation including date | Excel Discussion (Misc queries) | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Worksheet Functions | |||
Help with Concatenation | Excel Worksheet Functions |