Results 1 to 6 of 6

apply formula to selected cells via macro

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2009
    Location
    Connecticut, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    apply formula to selected cells via macro

    i've been struggling unsuccessfully, any help would be appreciated: trying to set up a macro to convert a range of user-highlighted(selected) cells to 3 significant figures:

    for example, convert 0.135564 to 0.136

    the equation i found elsewhere online (and humble thanks to the original author, whose name escapes me):
    ROUND(xx,3-(1+INT(LOG10(ABS(xx)))))

    but i can't quite figue out how to apply the equation to a selected range of cells via a macro... , any/all help greatly appreciated!

    thanks,
    -axe
    Last edited by Axe; 07-06-2009 at 11:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1