Results 1 to 2 of 2

Thread: Round the custom range of row

  1. #1
    Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    13

    Round the custom range of row

    Hi Friends,

    i would like to round the numbers in the range of cells and its rows(right side) for given below.

    range:"B8:B18", "B21:B21", "B24" and its used row

    Workbook attached for your reference.Is there any way to create VBA code for the same?

    Regards

    Prabhu
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Not clear what you are asking. Here you asking for rounding where as in the workbook you are seeking to multiply the cell value with 5. Please clarify.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Formula To Round Date Time To Decimal Minutes
    By mrprofit in forum Excel Help
    Replies: 1
    Last Post: 04-22-2014, 07:57 PM
  2. Replies: 3
    Last Post: 02-27-2014, 06:22 PM
  3. How to Add Custom List And Use in Custom Sorting
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-07-2013, 10:41 PM
  4. Copy Table Range Till Last Row Using VBA
    By ivandgreat in forum Excel Help
    Replies: 2
    Last Post: 05-09-2013, 05:41 PM
  5. Find the last row in a range
    By PcMax in forum Excel Help
    Replies: 7
    Last Post: 03-22-2013, 03:46 AM

Posting Permissions

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