Results 1 to 20 of 20

VBA Characters() Function Fails when the Cell Content Exceeds 261 Characters

Threaded View

  1. #1
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    VBA Characters() Function Fails when the Cell Content Exceeds 261 Characters

    I hope I don't need to give much description about the issue since the title and the code with an example file describes the issue very well.

    Sub ReplaceCharacters()
        Range("A1").Characters(300, 27).Delete
    End Sub
    Any suggestion how to overcome this issue?
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] code exceeds max. # of characters per line
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2014, 11:35 AM
  2. Merge cell content and remove duplicate characters
    By Jens D in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-19-2011, 11:40 AM
  3. Replies: 1
    Last Post: 08-17-2011, 05:59 AM
  4. importing data that exceeds 255 characters
    By dmac_59 in forum Excel General
    Replies: 0
    Last Post: 10-31-2007, 06:22 PM
  5. [SOLVED] Calculating a formula that exceeds 1,000 characters
    By w1nter11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 09:25 AM
  6. Delete A Word That Exceeds X Number Of Characters
    By brazen234 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2005, 12:40 PM
  7. Cell Content Greater than 24 Characters.
    By dlnorris in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2005, 04:18 PM
  8. Footers in which number of characters exceeds 255
    By DRK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-09-2005, 01: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