Results 1 to 2 of 2

Thread: Not VB but hopefully some help

  1. Aug 15th, 2000, 03:18 PM #1
    Stephen Warker
    Stephen Warker is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 2000
    Posts
    23
    I am trying to convert Lotus 123 to Excel 97. In lotus there is a cell with 30 some if statements. When i copy that over to Excel it gives me an error. I believe that the limit is 7 ifs in one cell, but i need to figure away around this with. A macro will not work unless it is automatic.

    Steve
    Stephen Warker
    Reply With Quote Reply With Quote
  2. Aug 15th, 2000, 03:23 PM #2
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    In Excel make a new module, and add a new public function to that. It will then be usable as a function, and will appear under "User-Defined Functions" in the list.
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width