+ Reply to Thread
Results 1 to 4 of 4

Round the custom range of row

  1. #1
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Round the custom range of row

    Hi Friends,

    The below VBA code helped me to multiply the range of row with the value of 5.

    i need to alter the code to round the value instead of multiply with Number 5.

    Kindly help to modify the code


    HTML Code: 

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Round the custom range of row

    Hi,

    You just need to change this line :
    Please Login or Register  to view this content.
    To something like this :
    Please Login or Register  to view this content.


    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Re: Round the custom range of row

    i am getting error.

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Round the custom range of row

    Please upload your workbook

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Round to nearest 10 using custom format
    By livelypilgrim in forum Excel General
    Replies: 3
    Last Post: 04-02-2014, 09:40 AM
  2. Custom Round Up Formula
    By John Bates in forum Excel General
    Replies: 4
    Last Post: 04-25-2011, 05:40 PM
  3. Custom round up sumation
    By Macee in forum Excel General
    Replies: 5
    Last Post: 01-05-2011, 06:30 AM
  4. Custom Formatting to round to millions
    By Scorpvin in forum Excel General
    Replies: 4
    Last Post: 03-01-2007, 01:53 PM
  5. Replies: 7
    Last Post: 03-16-2006, 08:55 PM

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