Hi Everyone,
I have a bit of a strange one here in Excel 2010. Basically I have a list of coordinates across from column B to column AWU and I need to concatenate them all into one cell with a space between each. In column AWV I am trying the following formula as an example.
<code>
=ConcatenateRange=(B4304:AWU4304)
</code>
The formula runs on this VBA (which adds a space between the coordinates in each cell.)
<code>
Function ConcatenateRange(rCells As Range)
'This function makes a concatenate range add a space between the contents of each cell
'in a selected range.
Dim vTemp As Variant
Application.Volatile
For Each vTemp In rCells
ConcatenateRange = ConcatenateRange & vTemp & " "
Next vTemp
End Function
</code>
the formula works fine and concatenates the contents. The problem however is when I then try copy and pasting the results somewhere else as "Paste Values"
I get the error as show in the title of this thread. The contents show in the cell but not in the formula bar. Every time that cell is then selected, the error shows.
The total cell contents does not exceed the 32,767 limit. It contains 25,000 or less.
Anyone know why this would happen?
Cheers,
I have a bit of a strange one here in Excel 2010. Basically I have a list of coordinates across from column B to column AWU and I need to concatenate them all into one cell with a space between each. In column AWV I am trying the following formula as an example.
<code>
=ConcatenateRange=(B4304:AWU4304)
</code>
The formula runs on this VBA (which adds a space between the coordinates in each cell.)
<code>
Function ConcatenateRange(rCells As Range)
'This function makes a concatenate range add a space between the contents of each cell
'in a selected range.
Dim vTemp As Variant
Application.Volatile
For Each vTemp In rCells
ConcatenateRange = ConcatenateRange & vTemp & " "
Next vTemp
End Function
</code>
the formula works fine and concatenates the contents. The problem however is when I then try copy and pasting the results somewhere else as "Paste Values"
I get the error as show in the title of this thread. The contents show in the cell but not in the formula bar. Every time that cell is then selected, the error shows.
The total cell contents does not exceed the 32,767 limit. It contains 25,000 or less.
Anyone know why this would happen?
Cheers,