Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range values
hi,
i would like to know if there is a way to take a range of cells like say from A2 to A15, and read those values, putting thm into an array. and then displaying them.. separated by commas in cell A1 (ONE cell only) of another sheet? Thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
range values
Sub ABC()
Dim cell as Range, s as String for each cell in Worksheets("Sheet1").Range("A2:A15") s = s & cell.value & "," Next worksheets("Sheet2").Range("B9").Value = Left(s,Len(s)-1) End Sub -- regards, Tom Ogilvy "geebee" wrote: hi, i would like to know if there is a way to take a range of cells like say from A2 to A15, and read those values, putting thm into an array. and then displaying them.. separated by commas in cell A1 (ONE cell only) of another sheet? Thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
SUMPRODUCT or SUMIF if any values in a range equal any values in another range | Excel Worksheet Functions | |||
There must be a way!!!--set cells' values equal to calculated values in another range | Excel Programming | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |