Trying to convert a Lotus 123 macro to Excel
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Trying to convert a Lotus 123 macro to Excel

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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?

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com