+ Reply to Thread
Results 1 to 3 of 3

Convert Cells to Numbers in VBA

  1. #1
    Registered User
    Join Date
    09-01-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    28

    Convert Cells to Numbers in VBA

    Hi all, I have the following script that allows me to convert cells to numbers, I'm having issues adding multiple rows to convert. I have rows S, T, AF, AG, & AH to convert. Any help would be grateful.

    Please Login or Register  to view this content.
    What am I missing, doing wrong? Thanks.
    Last edited by RBLearning; 05-31-2021 at 05:18 AM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Convert Cells to Numbers in VBA

    1.) "S", "T", "AF", "AG", "AH" are columns

    2.) Improper syntax: You cannot get the last row from multiple columns like this.
    Please Login or Register  to view this content.
    Try something like this...
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    09-01-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    28

    Re: Convert Cells to Numbers in VBA

    Thank you so much, works great.

+ 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. Convert Text Entries from textbox into numbers in target cells
    By Yoshiwara95 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2019, 03:31 PM
  2. [SOLVED] Convert numbers in multiple cells into one cell
    By Saturn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2017, 07:58 AM
  3. Replies: 1
    Last Post: 12-15-2014, 08:46 PM
  4. Replies: 8
    Last Post: 06-28-2014, 03:26 PM
  5. [SOLVED] Convert all numbers stored as text or custom formatted to numbers &no decimals - 40 sheets
    By synses in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 01:46 AM
  6. Replies: 2
    Last Post: 10-22-2009, 02:50 PM
  7. convert a number into two seperate numbers in two different cells.
    By odin1701 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2007, 06:54 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