Yes yes
Very god
But I want it by code
I want three column in one row
And three column in the next row
And three column in next row
Thanks for help
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of roberto mensa
Sent: Friday, November 26,
2010/11/26 عمر omar27...@gmail.com
Yes yes
Very god
But I want it by code
Sub test()
Dim rng1 As Excel.Range
Dim rng2 As Excel.Range
On Error Resume Next
Set rng1 = Intersect(ActiveSheet.UsedRange, Range(A:A))
Set rng1 = Application.InputBox( _
Select series, _
The number of rows for each column I want to choose
The main data like this
1
2
3
4
5
6
7
8
9
I want it on new sheet like this
1 4 7
2 5 8
3 9
I choose the number of
try the file ... you can changed the number of columns for the split
regards
r
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join