Copy column data

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sylvia <Sylvia.22hjqz_1138688101.8995@xxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 31 Jan 2006 00:11:50 -0600

Hi,

I want to write a macro by whic I will mention the number of characters
in one column then it should select only those number of characters for
the entire row.

eg. if I mention number of characters as 6 for 'column a', (I will
mention this in a seperate column. Macro should read this value from
that column) then it should copy only 6 characters of EACH cell in
'column a'

Do we anything kind of format etc for this thing?

Thanks,
Sylvia

--
Sylvia
------------------------------------------------------------------------
Sylvia's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30300
View this thread: http://www.excelforum.com/showthread.php?threadid=506668

.

Follow-Ups:
- Re: Copy column data
  - From: Tim Williams

Prev by Date: Re: Serial Data to ASCII
Next by Date: Re: Copy column data
Previous by thread: Removing/restoring toolbars
Next by thread: Re: Copy column data
Index(es):
- Date
- Thread

Relevant Pages

Re: Word Document Shows Unreadable Text
... Graham Mayor - Word MVP ... flash drives and say it is not a problem, then all of a sudden they ... As the macro did not work, we can assume that the problem was not ... these Asian-type characters at the top. ...
(microsoft.public.word.docmanagement)
Re: Word Document Shows Unreadable Text
... flash drives and say it is not a problem, then all of a sudden they ... come screaming to me for help when their most important file corrupts! ... As the macro did not work, we can assume that the problem was not ... these Asian-type characters at the top. ...
(microsoft.public.word.docmanagement)
Re: Word Document Shows Unreadable Text
... flash drives and say it is not a problem, then all of a sudden they ... come screaming to me for help when their most important file corrupts! ... As the macro did not work, we can assume that the problem was not ... these Asian-type characters at the top. ...
(microsoft.public.word.docmanagement)
Re: Change export delimitor?
... Both the substitute function (for a single cell) and the CleanEmUp macro ... "Dave Peterson" wrote: ... invisible characters but dec 013 and dec 010. ...
(microsoft.public.excel.misc)
RE: Parse a txt file and save as csv?
... number of characters. ... Run the macro. ... If DelimiterPosition> 0 Then ... Cells(RowCount, ColumnCount) = Data ...
(microsoft.public.excel.programming)