L
Lowell B. Copeland
Hello,
Example: The purpose is to use a macro to separate the two
letters of the state from a text string in a cell that
contains the city and the state, like "Boston MA".
Cell A1 Contains "Boston MA"
I want to be able to move ' MA' to cell B1 using a macro
The key strokes I am currently using are as follows:
Select cell A1 "Boston MA"
[F2] Edit
[Shift]+[Left Arrow][LeftArrow][LeftArrow] to select ' MA'
and the space character to the left of 'MA'
[Ctrl-X] to Cut ' MA'
[TAB] to move to cell B1
[Ctrl-V] to Paste ' MA' in cell B1
[Enter] to go to the next row in cell A2
When I create a macro of the above key strokes it takes
the value of the object cell A1 and pastes it into the A2
cell after I hit Enter.
It seems as though the programming is unable to read the
limited cut and paste command. It seems as though
the "Cell" is the smallest object VBA can handle. Is that
correct?
Is there some way to write a command that truncates a
string in a cell by cutting the last three characters of
the string and moving them to a new cell immediately to
the right of the active cell.
Any answer will help.
Thanks
Lowell
Example: The purpose is to use a macro to separate the two
letters of the state from a text string in a cell that
contains the city and the state, like "Boston MA".
Cell A1 Contains "Boston MA"
I want to be able to move ' MA' to cell B1 using a macro
The key strokes I am currently using are as follows:
Select cell A1 "Boston MA"
[F2] Edit
[Shift]+[Left Arrow][LeftArrow][LeftArrow] to select ' MA'
and the space character to the left of 'MA'
[Ctrl-X] to Cut ' MA'
[TAB] to move to cell B1
[Ctrl-V] to Paste ' MA' in cell B1
[Enter] to go to the next row in cell A2
When I create a macro of the above key strokes it takes
the value of the object cell A1 and pastes it into the A2
cell after I hit Enter.
It seems as though the programming is unable to read the
limited cut and paste command. It seems as though
the "Cell" is the smallest object VBA can handle. Is that
correct?
Is there some way to write a command that truncates a
string in a cell by cutting the last three characters of
the string and moving them to a new cell immediately to
the right of the active cell.
Any answer will help.
Thanks
Lowell