Results 1 to 6 of 6

Cop VBA to remove " " marks

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2018
    Location
    Glasgow
    MS-Off Ver
    2013
    Posts
    33

    Cop VBA to remove " " marks

    Hello,

    I have a button when clicked it generates and copies specific text. This is then pasted to another program that uses plain text. When pasted the text has the " mark at the beginning and end. Is there any way to remove this?

    Current VBA is:

    Select Case Range("H5").Value
            Case "ABC
                If Range("H5").Value = "ABC" Then
                    Range("C15").Value = "Statement 1 - BLAH BLAH BLAH”
                    Range("C16").Value = "Statement 2" & vbNewLine & "BLAH BLAH BLAH"
                    Rows("14:14").EntireRow.Hidden = False
                    Rows("15:15").EntireRow.Hidden = False
                    Rows("16:16").EntireRow.Hidden = False
                    Range("C15:C16").Copy
                End If
         End Select
    This produces the result of "Statement 1 - BLAH BLAH BLAH" "Statement 2 - BLAH BLAH BLAH". I want it to paste as Statement 1 - BLAH BLAH BLAH Statement 2 - BLAH BLAH BLAH.

    If anyone can help it would be greatly appreciated.

    Thanks
    Last edited by MonTheEck; 01-23-2019 at 12:43 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] drag-across of INDIRECT function does not change cell reference between " " marks
    By Pilly Ears in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-07-2018, 06:56 AM
  2. "Add Row" and "Remove Row" Buttons... adding rows with formulas down filled
    By excelatnothing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2015, 02:44 AM
  3. Replace "_" with "." and remove Trailing Alpha (where and when applicable)
    By chacamasur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-24-2014, 02:22 PM
  4. Replies: 1
    Last Post: 08-10-2014, 01:22 PM
  5. [SOLVED] VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 02:11 PM
  6. [SOLVED] UDF to remove "equivalent" expressions from a ";" delimited string
    By dredwolf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2012, 07:25 PM
  7. Remove "TRUE" "FALSE" words from a linked checkbox
    By MDCK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2008, 03:26 AM

Tags for this Thread

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