Prev: Copy to Named Range
Next: Column Array
From: Big Bitty Big on 29 Apr 2010 10:20 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
From: Jacob Skaria on 29 Apr 2010 10:29 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
From: Rick Rothstein on 29 Apr 2010 10:31 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 Bitty(a)discussions.microsoft.com> wrote in message news:E42C8F0343C1457CAB361740F4042748(a)microsoft.com... > 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

Pages: 1 Prev: Copy to Named Range Next: Column Array 