Results 1 to 11 of 11

Thread: Simple Loop

Threaded View

  1. Dec 5th, 2006, 12:30 PM #1
    The Webster
    The Webster is offline

    Thread Starter
    New Member
    Join Date
    Dec 2006
    Posts
    6

    Exclamation Simple Loop

    I have a spreadsheet with 495 rows and 12 columns full of equations that I wish to edit and calculate and then proceed to the next equation in the row below the existing line. I wish to then have this simple loop continue down the page to the end of the column.

    example:

    place cursor on an equation (any column) press {F2} then {F9} and {down}, repeat this loop 495 times?

    I've used this simple loop in basic and Lotus 123. I'm not well versed in Visual Basic within Excell.

    Do you have the power to translate the above loop to a working excell macro? "Oh mighty one"!
    Last edited by The Webster; Dec 7th, 2006 at 09:38 AM.
    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