+ Reply to Thread
Results 1 to 6 of 6

Editing a column with numbers

  1. #1
    Registered User
    Join Date
    02-27-2005
    Posts
    5

    Question Editing a column with numbers

    I made several columns with numbers, each column with about 1000 rows and filled them with numbers. In one of the columns I filled numbers with decimals. Now I would like to have those numbers round them up in that column (integers). I used the function ROUNDUP, but when trying to copy to each other cell, the content in the first edited cell with the function, also is copied into the other cells , which is what I do not want. I want to keep the actual content of every cell, and just add the =roundup() function to every other cell. Can someone help how to solve this?. I guess a VB macro can solve it. Thanks.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464
    try this
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-27-2005
    Posts
    5

    Column VBA macro

    I tried the macro you suggested, but it does not work. It seems is looking for a formula inside the cell, but in the cell I just have number. This is what I think, I barely understand VB programming.
    Any other suggestion??

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464
    I don't know if I fully understand your problem

    try the code.
    the code will Round to the integer if cell contains numeric value

    Please Login or Register  to view this content.
    jindon

  5. #5
    Registered User
    Join Date
    02-27-2005
    Posts
    5

    Talking numbers in columns

    Jindon:
    The macro you suggested worked perfectly.!!
    Thank you so much.

    Luis G. Hernandez

  6. #6
    Registered User
    Join Date
    02-27-2005
    Posts
    5

    Macro about Rounding

    Jindon:
    As I said, the macro worked really ok. There is just one little problem that I did not detected when testing the macro the first time. I tested it with just one column, and so it did work really fine. But when I took the macro to the real example, where there are lot of other columns, the macro worked fine, but it rounded up all the other columns which I didn't want that. Can you add something to that macro telling that when it finds the last ocuppied cell in the current column it stops looking for other columns in that worksheet.??

    Thanks again for your help.

+ Reply to Thread

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