hunna
11-27-2011, 04:17 PM
Hi there,
I have a certain data copied from text file, for example "ASEWDYFKS".
I want to have a macro that I can assign a range to input such data,
supposed that the first range to be input is A3
so I expect the output would be
in range A3 -- > A
in range B3 -- > S
in range C3 -- > E
.
.
.
in range I3 -- > S
------------------------------
I have a macro that can manage this task but it's quite slow. I first paste "ASEWDYFKS" into textbox1 (in Userform) and add "3" into textbox2 (in Userform).
My macro then pastes the data (textbox1) to a certain range followed by adding spaces between letters, text to column and then pastes to a desired range.
------------------------------
any help would be appreciated,
thanks,
PS I am not sure if it's clear, sorry for my english
I have a certain data copied from text file, for example "ASEWDYFKS".
I want to have a macro that I can assign a range to input such data,
supposed that the first range to be input is A3
so I expect the output would be
in range A3 -- > A
in range B3 -- > S
in range C3 -- > E
.
.
.
in range I3 -- > S
------------------------------
I have a macro that can manage this task but it's quite slow. I first paste "ASEWDYFKS" into textbox1 (in Userform) and add "3" into textbox2 (in Userform).
My macro then pastes the data (textbox1) to a certain range followed by adding spaces between letters, text to column and then pastes to a desired range.
------------------------------
any help would be appreciated,
thanks,
PS I am not sure if it's clear, sorry for my english