PDA

View Full Version : Solved: macro to call "paste special"



copyt
03-17-2012, 08:05 AM
I need help for a macro that can call this window (attached)



Thanks,

p45cal
03-17-2012, 08:49 AM
Either:
Application.Dialogs(xlDialogPasteSpecial).Show
or x = Application.Dialogs(xlDialogPasteSpecial).Show
if you want to detect whether the user clicked Cancel.

copyt
03-17-2012, 12:46 PM
Thank you very much :) :bow: :yes