+ Reply to Thread
Results 1 to 3 of 3

how to put string of characters to a particular cell

  1. 03-04-2014, 09:29 PM #1
    amethystfeb
    amethystfeb is offline
    Registered User
    Join Date
    07-31-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    64

    how to put string of characters to a particular cell

    Hi,

    Im writing a vba code in which i need the following huge line of text in cell A1.

    When it tried to hardcode i get complilation error.


    Please Login or Register  to view this content.
    Any suggestions
    Reply With QuoteRegister To Reply
  2. 03-04-2014, 09:40 PM #2
    ajryan88
    ajryan88 is offline
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: how to put string of characters to a particular cell

    Sorry, didn't realise you said VBA. Will post a solution soon
    Reply With QuoteRegister To Reply
  3. 03-04-2014, 09:44 PM #3
    ajryan88
    ajryan88 is offline
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: how to put string of characters to a particular cell

    Try this: 
    Please Login or Register  to view this content.
    Hope this helps
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Remove duplicate characters from a text string in a cell
    By sam99 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-22-2020, 06:10 PM
  2. Split String into 4 Parts - Max 30 Characters per Cell and Whole Words
    By keithm_007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 05:56 AM
  3. Finding repeating multiple characters from a string in cell
    By varg111 in forum Excel General
    Replies: 1
    Last Post: 11-04-2012, 07:51 AM
  4. [SOLVED] How to remove string characters in a cell
    By itsmejan24 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-10-2012, 03:02 PM
  5. Remove last 4 characters from cell string?
    By chris-uk-lad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2009, 07:01 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1