| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data from multiple variable length columns to one column
Many thanks for the speedy responses
Robert In message , Robert writes I would like to copy and paste 93 variable length columns into one continuous column. I understand that I can use the following to locate the first unused cell and paste the copied columns data: Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Select Selection.PasteSpecial Paste:=xlPasteValues I imagine that what I need is some form of loop to pick up the data in the 93 columns. Grateful for any advice |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Length Columns | Excel Discussion (Misc queries) | |||
| Graphing Variable-length columns | Charts and Charting in Excel | |||
| Referencing a Value in variable length columns. | Excel Worksheet Functions | |||
| Sum a Column of Variable length | Excel Discussion (Misc queries) | |||
| Sum a column of variable length? | Excel Discussion (Misc queries) | |||
![Robert[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
