Thread
:
converting Lotus 123 macro to Excell macro
View Single Post
#
2
Don Guillett
Posts: n/a
{edit}{home}{Del 7}{d}
reads as: open cell in edit mode - move to the home position of the row -
delete seven characters - move down one line - end macro
activecell=left(activecell,len(activecell)-7))
activecell.offset(1).select
However all of this can be done much quicker for all cells WITHOUT any
selections.
{edit}{L 10}{BS 30}{D}
Don't understand what is happening with the second macro since it appears to
do nothing
--
Don Guillett
SalesAid Software
"mark h" wrote in message
...
I need to parse/edit one line at a time usng the same one-line macro.
When I
use macro-recorder, it links to the specific cell reference. I need the
below macros to be free from specific cell references - it needs to run on
the current cell and move down one row.
{edit}{home}{Del 7}{d}
reads as: open cell in edit mode - move to the home position of the row -
delete seven characters - move down one line - end macro
and
{edit}{L 10}{BS 30}{D}
reads as: open cell in edit mode - move left 10 characters - backspace 30
characters - move down one line - end macro
Is there a simple macro that can do these?
thanx
Mark
Reply With Quote