Cannot cut and paste in Excel

Asked By 10 points N/A Posted on -
qa-featured

 

 I created a worksheet which is used to upload information into a database that has various validations and database insert macros running in the background.

But when I attempt to Cut and Paste rows into my worksheet, I get an alert message box with the title "Microsoft Visual Basic" and then the message 'File not found'.

When I hit the “OK” button in the window another alert message box is opened saying "Microsoft Excel cannot paste the data". However when I close this message box the data is pasted into the worksheet. 

Could it be that there is something wrong with my VBA code?

SHARE
Best Answer by JayPB
Best Answer
Best Answer
Answered By 0 points N/A #83082

Cannot cut and paste in Excel

qa-featured

Hey,

This error is obvious due to occasional misbehavior of rdclip.exe avoiding the use of copy function in MS Excel. This matter can be temporarily resolved by killing this process.

You can do that from Windows Task Manager :

  • Process tab or Start -> Run ->type ‘taskkill/F/IM rdclip.exe and click ok.

You can also try opening MS Excel in Safe Mode and check if the copy function is working:

The following command will open MS Excel without Add-ins or hidden workbooks.

  • Navigate to Start -> Run and type "C:Program FilesMicrosoft OfficeOfficeExcel.exe /Safe” or “Excel.exe/safe”.
  • After that go to Tools -> Addins ->uncheck all addins and exit Excel.

Otherwise the problem will be with the XLSTART directory and you need to clean that directory.

Answered By 0 points N/A #83084

Cannot cut and paste in Excel

qa-featured

 

It seems to me that your rdpclip.exe is malfunctioning, resulting the prevention of using Copy function in Windows or Office. A temporary fix for this is to the process of rdpclip.exe.
 
So go to Run from Start menu and type – – taskkill /F /IM rdpclip.exe
 
Answered By 0 points N/A #83085

Cannot cut and paste in Excel

qa-featured

Here all solution I like it.

Answered By 0 points N/A #83087

Cannot cut and paste in Excel

qa-featured

Hi,

Yes, this seems a potential issue with your VBA code. Actually the VBA code is like a remote control of Excel. The best solution is to use MACRO instead of VBA code. If you are not familiar with MACROs then I will suggest that please turn off your Excel Alert window as you are achieving your desired results.

You can use the following command:

Application.DisplayAlerts = Flase

Please let me know if this works for you otherwise please send me your VBA code and I will go through with your code and will suggest some other best and possible solutions. Thanks.

Regards,

ELM_Steve

Related Questions