Results 1 to 9 of 9

How to copy value of selected cell to windows clipboard?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-08-2013
    Location
    ankara
    MS-Off Ver
    Excel 2010
    Posts
    134

    Arrow How to copy value of selected cell to windows clipboard?

    Sub basvuruac()
        With New DataObject
            SetText ActiveCell.Value
            PutInClipboard
        End With
        On Error GoTo 1
        Call Shell(Environ$("COMSPEC") & " /c ""C:\Documents and Settings\burak\Desktop\# Başvurular\Bitmeyenler\islembekleyen.bat""", vbNormalFocus)
        Exit Sub
    1:           MsgBox Err.Description
    End Sub
    I have the code above. I need to copy active cell value for my other uses. Someone said the answer above in bold but then I got error. Could you give me a hint please?

    Selection.Copy
    Application.CutCopyMode = False

    doesn't work.

    Selection.Copy

    works but I don't want this cell remain as selected.
    Last edited by 1tane1; 05-21-2013 at 06:34 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1