I want to join the values of a range of cells (say 1, 2, 5, and 8) to produce
the number 1258, which can then be used in other calculations. Any ideas on
how to do this?

I'm using Excel from Office 2000

Many thanks

Formula
=--(C9&D9&E9&F9)

VBA code
varData = --(Range("C9") & Range("D9") & Range("E9") & Range("F9"))


--
Jacob (MVP - Excel)


"Big Bitty" wrote:

I want to join the values of a range of cells (say 1, 2, 5, and 8) to produce
the number 1258, which can then be used in other calculations. Any ideas on
how to do this?

I'm using Excel from Office 2000

Many thanks

You can concatenate the ranges and then convert the result to a numerical
data type...

ComboNumber = CLng(Range("A1") & Range("E5") & Range("J8") & Range("H9"))

If you told us more about your set up (will cells vary in number, are they
always contiguous, are they always in a single column, etc.), we might be
able to give you better code.

--
Rick (MVP - Excel)



"Big Bitty" <Big wrote in message
...
I want to join the values of a range of cells (say 1, 2, 5, and 8) to
produce
the number 1258, which can then be used in other calculations. Any ideas
on
how to do this?

I'm using Excel from Office 2000

Many thanks