Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lotus 123 macros 1

Status
Not open for further replies.

syl93

Programmer
May 17, 2002
15
US
Is there a way to get a list of all macros that are defined in a Lotus 123 spreadsheet?
I am converting Lotus 123 spreadsheets to Excel. These are spreadsheets that I am not familiar with and I need a way to make sure that if there are any macros defined in the Lotus spreadsheets that they get converted properly to Excel.
Thanks in advance for any info!
 
A macro in 123 is merely a named range. In 123 classic you can type /rnt and lotus will create a table of all range names and the corresponding cell(s). Otherwise you can click on the navigator for a list of range names, or you can click on Range in the tool bar.
 
Although entering a value in hh:mm:ss format is accepted in LOTUS 1-2-3, how can I sum the column of time values and get a correct hh:mm:ss sum?
hunymuners@aol.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top