+ Reply to Thread
Results 1 to 3 of 3

Add Rounding off Formula to selected columns

  1. #1
    Forum Contributor
    Join Date
    05-01-2020
    Location
    CHENNAI
    MS-Off Ver
    EXCEL 2010
    Posts
    105

    Post Add Rounding off Formula to selected columns

    Hi
    Please help me to create VBA code. If selected columns cells contain number then rounding off formula to be added ( Round,0) if any cells does not have numbers, to be ignored round formua.( In my range of columns I have text and blank cell also)

  2. #2
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: Add Rounding off Formula to selected columns

    Choose a better way for you.
    Please Login or Register  to view this content.
    Best Regards,
    Maras.

  3. #3
    Forum Contributor
    Join Date
    05-01-2020
    Location
    CHENNAI
    MS-Off Ver
    EXCEL 2010
    Posts
    105

    Re: Add Rounding off Formula to selected columns

    Hi Maras_mak. Thank you so much. The below codes i expected.

    Sub Round_2()
    Dim rng As Range, e As Range

    Set rng = Selection.SpecialCells(xlCellTypeConstants, 1)
    For Each e In rng
    e = WorksheetFunction.Round(e, 0)
    Next
    End Sub

+ 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. [SOLVED] Excel 2010 - Comparing 2 Columns - Keeping Formula Fixed on the selected Row
    By LauuluOVini in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2018, 06:44 AM
  2. Rounding columns
    By Kiredoryor in forum Excel General
    Replies: 3
    Last Post: 05-02-2018, 06:08 PM
  3. Replies: 10
    Last Post: 09-24-2017, 04:17 AM
  4. Array formula to return list of unique items from selected columns only
    By jlawton1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2016, 04:53 AM
  5. [SOLVED] Rounding particular columns to the nearest 5
    By jaymoore in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-11-2015, 11:07 AM
  6. [SOLVED] Macros to transpose from multiple columns to selected columns and maintaining cell format
    By rrajnish in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2013, 01:45 PM
  7. [SOLVED] Merging selected sheets with selected columns into another sheet
    By harry_1805 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 01:51 PM

Tags for this Thread

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