Hi,
I wonder if is there a way to "listen' to a PasteSpecial command and its parameters in excel? I'm writing a vba code to manage the Range.PasteSpecial method and realized I need a way to know if the Transpose parameter of the action defined by the user is true or false, so I can treat the source data accordingly. Offcourse, since I don't know when Transpose is TRUE, this piece of code below does not really work.
Please Login or Register to view this content.
Last edited by tisouza; 06-13-2022 at 01:51 PM.
TransBool will now be TRUE or FALSE depending on whether or not the PasteSpecial was transposed or not...
Please Login or Register to view this content.
& here is your code properly indented...
Please Login or Register to view this content.
Thank you for the help with indenting.
It seems to me that the value for the boolean of transpositon, which I itended to keep in 'Transpose' in the same way as you put in 'TransBool', remains undefined. I still do not understand how to capture this boolean from the action of Copy>PasteSpecial and assign it to the variable "Transpose".
you can create a function called 'Transpose'
i.e.
and run it in your module whenever you wantPlease Login or Register to view this content.
In a word, no. And any sort of Paste Special, will appear as simply that in the Undo list.Originally Posted by tisouza
Rory
Whenever you write "Transpose" in a module, it will execute the function above... it's not a variable but it sort of acts like one
Since you changed your title, my posts are no longer relevant
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks