| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conbine cells into one column
Hi,
I have a database with 70 columns and need to get rid of rows with identical information. I just recored the following macro, but it is lenghthy + there is 256 char limitation. ActiveCell.FormulaR1C1 = "=RC[-70]&RC[-69]&RC[-68]&RC[-67] .... so on" Is there is a way to do it differently? Thank you -- ______ Regards, Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conbine cells into one column
tried something like this, limiting to 255 char, not perfect but will do for
the time being Dim form As String n = 70 form = "" For i = n To 1 Step -1 form = form & "&RC[-" & i & "]" Next form = "=left(" & Right(form, Len(form) - 1) & ",255)" ActiveCell.FormulaR1C1 = form -- ______ Regards, Greg "Greg" wrote: Hi, I have a database with 70 columns and need to get rid of rows with identical information. I just recored the following macro, but it is lenghthy + there is 256 char limitation. ActiveCell.FormulaR1C1 = "=RC[-70]&RC[-69]&RC[-68]&RC[-67] .... so on" Is there is a way to do it differently? Thank you -- ______ Regards, Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| conbine lists from multiple worksheets | Excel Discussion (Misc queries) | |||
| macro to transpose cells in Column B based on unique values in Column A | Excel Programming | |||
Hybrid Mode
