Trying to convert a Lotus 123 macro to Excel

dping222 · Apr 8th, 2002, 03:47 PM

Hello,

I am trying to perform the following operation in excel:

{IF @CELLPOINTER("TYPE")<>"B"}{DOWN}{BRANCH COPYLINE}
{IF @CELLPOINTER("TYPE")="B"}{UP}{EDIT-COPY}{DOWN}{EDIT-PASTE}{BRANCHCOPYLINE}
{BRANCHCOPYLINE}

Any suggestions?

Jay Petrulis · Apr 8th, 2002, 03:49 PM

Hi,

Not too many Lotus users here. Please explain what the 123 code does -- in detail where necessary -- and we can likely code it in Excel.

Bye,
Jay

Jack in the UK · Apr 8th, 2002, 05:08 PM

Hi
Ive commented o this B4 IBM Lotus will or part willwork in VBA but to be honest your need to re write the whole code..

Sorry not very compatable,,,,

MS homepage has details on what wil and wont convert for reference .. little help i know.. sorry.

dping222 · Apr 9th, 2002, 03:11 PM

Basically, all I'm doing is filling in the blanks with the number above within the column:

41114 41114
blank 41114
41151 turns into 41151
blank 41151
blank 41151
blank 41151
41161 41161
blank 41161

It simply evaluates the current cell and if blank, goes up and copies the cell above it and pastes it into the empty cell until it hits another number and then repeats the process.

Thanks alot for your help guys!

Apr 8th, 2002, 05:08 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Ive commented o this B4 IBM Lotus will or part willwork in VBA but to be honest your need to re write the whole code.. Sorry not very compatable,,,, MS homepage has details on what wil and wont convert for reference .. little help i know.. sorry. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 03:47 PM	#1
dping222 New Member Join Date: Apr 2002 Posts: 3	Hello, I am trying to perform the following operation in excel: {IF @CELLPOINTER("TYPE")<>"B"}{DOWN}{BRANCH COPYLINE} {IF @CELLPOINTER("TYPE")="B"}{UP}{EDIT-COPY}{DOWN}{EDIT-PASTE}{BRANCHCOPYLINE} {BRANCHCOPYLINE} Any suggestions?

Apr 8th, 2002, 03:49 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Not too many Lotus users here. Please explain what the 123 code does -- in detail where necessary -- and we can likely code it in Excel. Bye, Jay

Apr 9th, 2002, 03:11 PM	#4
dping222 New Member Join Date: Apr 2002 Posts: 3	Basically, all I'm doing is filling in the blanks with the number above within the column: 41114 41114 blank 41114 41151 turns into 41151 blank 41151 blank 41151 blank 41151 41161 41161 blank 41161 It simply evaluates the current cell and if blank, goes up and copies the cell above it and pastes it into the empty cell until it hits another number and then repeats the process. Thanks alot for your help guys!