Results 1 to 14 of 14

Change text to values and adjust column location

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    263

    Change text to values and adjust column location

    Hopefully you can help me get this figured out!!

    DoEvents
    Range("GW:GW, JC:JE").NumberFormat = "0.00"         'choose number format here
    On Error Resume Next
    For Each cell In Range("GW:GW, JC:JE").SpecialCells(xlConstants)
        cell.Value = CDbl(cell.Value)
    Next cell
    I am using the same code as above, but changed the columns. If I use the columns above, no issues. If I use the new columns (same data in the columns) Excel freezes up. Error: Excel cannot complete the task with available resources. Keep in mind, that if I run the same code on the same data, there are no issues. I only changed the column from ("GW:GW, JC:JE") to ("D:F"). Been at it for 3 hours, changing things around ect. to no avail!!!!

    My Code:
    DoEvents
    Range("D:F").NumberFormat = "0.00"         'choose number format here
    On Error Resume Next
    For Each cell In Range("D:F").SpecialCells(xlConstants)
        cell.Value = cell.Value * 1
    Next cell
    Last edited by JBeaucaire; 10-01-2014 at 01:00 AM. Reason: moved to its own thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto Adjust Stacked Column Need to Adjust Legend
    By tbren in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-29-2013, 01:56 PM
  2. Automatically adjust column width to fit text? (Pivot)
    By ThomasCarter in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-28-2013, 08:19 AM
  3. [SOLVED] Excel wrapped text column auto adjust
    By oldskool in forum Excel General
    Replies: 1
    Last Post: 01-24-2013, 07:48 AM
  4. [SOLVED] How do I change location of figures within a column
    By 1911dan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2005, 01:06 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