Lotus Macro
 

Hi

I would like to know how to set a macros similar to the ones I used in Lotus
.... for Example

In Lotus when I moved around when setting a macro it would just go up and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just move up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the end of
a cell and delete the last five characters and then go to the next cell.
when I try to do that in Excel ... it relaces the whole line with the one I
used in the macro ... How do I change the macro to just delete the last five
characters of each cell and then go on to the next cell ...

Thanks

Gordon

Lotus Macro
 

question 1. use activecell.offset(1,0).select to go down one. But you do NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post yours for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go up and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the end
of
a cell and delete the last five characters and then go to the next cell.
when I try to do that in Excel ... it relaces the whole line with the one
I
used in the macro ... How do I change the macro to just delete the last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon

Lotus Macro
 

Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me trouble
....

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon

"Don Guillett" wrote in message
...
question 1. use activecell.offset(1,0).select to go down one. But you do
NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post yours
for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go up and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the end
of
a cell and delete the last five characters and then go to the next cell.
when I try to do that in Excel ... it relaces the whole line with the one
I
used in the macro ... How do I change the macro to just delete the last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon

Lotus Macro
 

You did NOT post your efforts.

Sub strip5()
For Each c In Selection
c.Offset(0, 1) = Left(c, Len(c) - 5)
Next
End Sub

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me trouble
...

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon

"Don Guillett" wrote in message
...
question 1. use activecell.offset(1,0).select to go down one. But you do
NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post yours
for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go up
and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just
move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the
end
of
a cell and delete the last five characters and then go to the next
cell.
when I try to do that in Excel ... it relaces the whole line with the
one
I
used in the macro ... How do I change the macro to just delete the last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon

Lotus Macro
 

Thanks very much ... got it to werk just fine

Is there is a manual for this that is for beginners like me ... the help in
excel is next to useless for me ...

Regards,

Gordon

"Don Guillett" wrote in message
...
You did NOT post your efforts.

Sub strip5()
For Each c In Selection
c.Offset(0, 1) = Left(c, Len(c) - 5)
Next
End Sub

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me
trouble
...

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon

"Don Guillett" wrote in message
...
question 1. use activecell.offset(1,0).select to go down one. But you
do
NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post
yours
for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go up
and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just
move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the
end
of
a cell and delete the last five characters and then go to the next
cell.
when I try to do that in Excel ... it relaces the whole line with the
one
I
used in the macro ... How do I change the macro to just delete the
last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon

Lotus Macro
 

There are many excel books for sale by several on this list. Goto your
computer store or hang around here and learn. Practice and the macro
recorder are your friend.

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks very much ... got it to werk just fine

Is there is a manual for this that is for beginners like me ... the help
in
excel is next to useless for me ...

Regards,

Gordon

"Don Guillett" wrote in message
...
You did NOT post your efforts.

Sub strip5()
For Each c In Selection
c.Offset(0, 1) = Left(c, Len(c) - 5)
Next
End Sub

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me
trouble
...

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon

"Don Guillett" wrote in message
...
question 1. use activecell.offset(1,0).select to go down one. But you
do
NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post
yours
for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used
in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go
up
and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just
move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the
end
of
a cell and delete the last five characters and then go to the next
cell.
when I try to do that in Excel ... it relaces the whole line with
the
one
I
used in the macro ... How do I change the macro to just delete the
last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon

Lotus Macro
 

--
steveB

Remove "AYN" from email to respond
"Gordon" wrote in message
...
Thanks very much ... got it to werk just fine

Is there is a manual for this that is for beginners like me ... the help
in excel is next to useless for me ...

Regards,

Gordon

"Don Guillett" wrote in message
...
You did NOT post your efforts.

Sub strip5()
For Each c In Selection
c.Offset(0, 1) = Left(c, Len(c) - 5)
Next
End Sub

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me
trouble
...

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon

"Don Guillett" wrote in message
...
question 1. use activecell.offset(1,0).select to go down one. But you
do
NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post
yours
for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used
in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go up
and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just
move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the
end
of
a cell and delete the last five characters and then go to the next
cell.
when I try to do that in Excel ... it relaces the whole line with the
one
I
used in the macro ... How do I change the macro to just delete the
last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon

Lotus Macro
 

Check out these sites: (there are many more)

http://www.cpearson.com/excel.htm

http://www.contextures.com/index.html

http://www.peltiertech.com/index.html

http://www.rondebruin.nl/tips.htm from this site download Google
Search add-in

www.tushar-mehta.com


Go to Google and search for "Excel" and "Tutorial"

And finally - just monitor this ng - great stuff here...
--
steveB

Remove "AYN" from email to respond
"Gordon" wrote in message
...
Thanks very much ... got it to werk just fine

Is there is a manual for this that is for beginners like me ... the help
in excel is next to useless for me ...

Regards,

Gordon

"Don Guillett" wrote in message
...
You did NOT post your efforts.

Sub strip5()
For Each c In Selection
c.Offset(0, 1) = Left(c, Len(c) - 5)
Next
End Sub

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Thanks for your help ...

I got the first one to work just fine but the 2nd one is giving me
trouble
...

for/each macro with c.value=Left(c,len(c)-5)

I was getting an error when I coppied that into the macro

any further suggestions ??

Regards,

Gordon

"Don Guillett" wrote in message
...
question 1. use activecell.offset(1,0).select to go down one. But you
do
NOT
need to select cells in excel to do something to them. Use
activecell.offset(1).value="Lotus"
question2 use a for/each macro with c.value=Left(c,len(c)-5). Post
yours
for
comments

--
Don Guillett
SalesAid Software

"Gordon" wrote in message
...
Hi

I would like to know how to set a macros similar to the ones I used
in
Lotus
... for Example

In Lotus when I moved around when setting a macro it would just go up
and
down ... no matter where I start from ...
In excel ... it references specific cells to go to ... how do I just
move
up
or own with out going to a specific cell in an Excel macro??

Second .... I had an editing macro in Lotus where I could go to the
end
of
a cell and delete the last five characters and then go to the next
cell.
when I try to do that in Excel ... it relaces the whole line with the
one
I
used in the macro ... How do I change the macro to just delete the
last
five
characters of each cell and then go on to the next cell ...

Thanks

Gordon