Consulting

Results 1 to 3 of 3

Thread: Solved: macro to call "paste special"

  1. 03-17-2012, 08:05 AM #1
    copyt
    copyt is offline
    VBAX Regular
    Joined
    Mar 2012
    Posts
    55

    Solved: macro to call "paste special"

    I need help for a macro that can call this window (attached)



    Thanks,
    Attached Images Attached Images
    Reply With Quote Reply With Quote
  2. 03-17-2012, 08:49 AM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,881
    Either:
    [VBA]Application.Dialogs(xlDialogPasteSpecial).Show
    [/VBA]or [VBA]x = Application.Dialogs(xlDialogPasteSpecial).Show
    [/VBA]if you want to detect whether the user clicked Cancel.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
  3. 03-17-2012, 12:46 PM #3
    copyt
    copyt is offline
    VBAX Regular
    Joined
    Mar 2012
    Posts
    55
    Thank you very much
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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