2010/11/26 عمر
> 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", _
"Input",
, 2010 1:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy range to other sheet but split it to 3
column
try the file ... you can changed the number of columns for the split
regards
r
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
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 ro