复制和粘贴/剪切和粘贴在excel宏中无法正常工作 [英] Copy and paste/Cut and paste is not working properly in excel macro

问题描述

我在宏中有一个场景，其中复制和粘贴/剪切和粘贴不起作用。

I have a scenario in macro where copy and paste/cut and paste should not work.

当我复制/剪切A1单元格中的数据，并尝试粘贴B1单元格，它不应该被粘贴，它应该抛出验证消息。我正在使用下面的宏代码，但它无法正常工作。

When I copy/cut the data from A1 cell and trying to paste in B1 cell it should not get pasted and it should throw an validation message. I'm using the below macro code, but it is not working properly.

Sathish Tallam

Sathish Tallam

推荐答案

Hello Sathish，

Hello Sathish,

您是否尝试调试代码？ 

Did you try to debug the code? 

这篇关于复制和粘贴/剪切和粘贴在excel宏中无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！