Error after pasting Macro in Excel

Asked By camford 0 points N/A Posted on - 02/21/2012

Hi all,

Why is it that after I paste a Macro in MS Excel, I always get this error:

Microsoft Visual Basic

Compile error:

Expected: end of statement

 

Have you ever seen this error message? How did you solve this problem?

Thanks again for your help!

• Status: Open
• Question Views: 1109
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Scott Douglas

Go To Solution

Answered By dilipkumararora3 0 points N/A #93417

Error after pasting Macro in Excel

Hello,

   Macros are development tools available in Microsoft Excel, they are used to record sequence of actions for a task.

As per viewing your screen shot, it seems like that you have entered a wrong formula for running macro. Please note that when record a macro in excel, it must follow the Syntax of the excel formulas, not the, Visual basic syntax..

Please resend your question with proper screen shot, so i can help you some more in details…

Thanks

About dilipkumararora3

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/21/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Scott Douglas 5 points N/A #93418

Error after pasting Macro in Excel

 

Hi,

You didn’t mention which Microsoft Office package are using. I guess you are having trouble with Office 2000. This can be occurred due to start or quit module mod_voice. Please follow the instructions I have given below.

1.       Go to My Computer and locate the following path

C: Program Files Microsoft Office Office XLStart

2.       In the XLStart folder, select the UT200 and right click on it then select Delete.

3.       Then you need to find a following file. Search on your computer and delete all the files permanently. You can delete files permanently by pressing SHIFT key and the DELETE together.

File name is shown below.

Ut2000.dot

 

Hope this will solve your problem.

 

About Scott Douglas

Questions
3

Answers
102

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 12/19/2012
• Question Category: MS Excel

Answered By Robert K Lewandowski 5 points N/A #93420

Error after pasting Macro in Excel

As there are many causes for compile error like that has many way to solve this problem.

Go this Techyv page " Compile error message in MS Visual Basic"  and get more techniques.

About Robert K Lewandowski

Questions
8

Answers
23

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/13/2014
• Question Category: MS Excel