Results 1 to 2 of 2

Converting a number to a cell string?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Converting a number to a cell string?

    Hello,
    Can someone help me concatenate a number to a string that identifies a cell. Please view below:


    Dim xxx as string
    Dim TopRow as integer
    
    
    TopRow = 1
    
    xxx = "B" & (TopRow + 5)
    xxx = Chr(34) & xxx & ":B10"
    
    Range(xxx)
    'Range("xxx:B10")
    'Range("B6:B10")


    Thank you so much for your help!
    RN
    Last edited by RustyNail; 02-21-2018 at 10:38 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Converting a number with a specified number of decimal places into a string
    By lostest in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2016, 09:38 AM
  2. Issue converting string to number..
    By cummins in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2011, 04:07 PM
  3. Converting text string to number string
    By cdworin in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-18-2010, 06:31 AM
  4. converting number string into time
    By paintballlovr in forum Excel General
    Replies: 12
    Last Post: 07-15-2010, 04:52 PM
  5. Replies: 3
    Last Post: 05-01-2007, 08:25 PM
  6. Converting string of letters to Number
    By sebkavam in forum Excel General
    Replies: 6
    Last Post: 07-26-2006, 05:55 PM
  7. [SOLVED] converting number string to number with decimal
    By rortiz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-15-2005, 04:05 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