07-12-2012, 02:36 PM
|
 |
Multi-Technologist
Super Moderator
* Expert *
|
|
Join Date: May 2004
Location: Michigan
Posts: 3,740
|
|
Here is an example for transposing from rows to columns, if that is what you mean:
Code:
Range("A1:C1").Select
Selection.Copy
Range("A2:A4").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Otherwise, please provide a more detailed example of what you are trying to do. |
__________________
"May the code that you write never work in ways that you didn't expect; and may the code that you didn't write never require you to maintain it". - Ancient Chinese Proverb
|
how use text to columns ??
Linear Mode
