+ Reply to Thread
Results 1 to 3 of 3

How to save contents of a cell into a string

Hybrid View

  1. 06-15-2007, 03:54 PM #1
    help000
    help000 is offline
    Registered User
    Join Date
    06-08-2007
    Posts
    22

    How to save contents of a cell into a string

    How to save contents of a cell into a string?
    Thanks

    I tried:

    
Worksheets("Sheet1").Range("E11").value = StringofContents
    But did not work, I also tried it the other way around 

    
StringofContents = Worksheets("Sheet1").Range("E11").value
    but got an error, any thoughts?
    Reply With QuoteRegister To Reply
  2. 06-15-2007, 04:10 PM #2
    boylejob
    boylejob is offline
    Forum Contributor boylejob's Avatar
    Join Date
    02-22-2007
    Location
    Forest City, NC
    MS-Off Ver
    2003
    Posts
    562
    Hi Help000,

    Your second one should work. I tried it on my end and it worked fine.

    What is the error message you are getting?
    Sincerely,
    Jeff
    Reply With QuoteRegister To Reply
  3. 06-19-2007, 10:46 AM #3
    help000
    help000 is offline
    Registered User
    Join Date
    06-08-2007
    Posts
    22
    Yes it works, thanks, just didn't define variable
    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)

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