LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 692
Default 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












 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Yet another Lotus macro question Monty New Users to Excel 2 February 7th 07 01:44 PM
HOW DO I RUN A LOTUS MACRO IN EXCEL GM Excel Discussion (Misc queries) 0 November 14th 06 08:37 PM
converting Lotus 123 macro to Excell macro mark h Excel Discussion (Misc queries) 6 July 11th 05 01:28 PM
CONVERTING A LOTUS MACRO Gary B[_4_] Excel Programming 0 October 29th 03 05:45 AM
Lotus 1-2-3 macro Felisca Wiratama Excel Programming 2 July 9th 03 08:35 PM


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"