Excel VBA

Copper Contributor

Hello,

 

image.png

 I am trying to use the Visual Basic on my Mac but when I Click on "worksheet" to type the code this message appears to me: 

"Variable uses an Automation type not supported in Visual Basic" 

4 Replies

@Isabela9 

 

Can you give us a clue about what code you are using and on which Module i.e. on Sheet Module or on Standard Module?

I didn't use any code because the excel wouldn't let me type anything on the worksheet, that's when the message appears to me.
Developer > Visual Basic > Worksheet > The error appears 

@Subodh_Tiwari_sktneer 

Thank you, that is the exact problem I'm having. After I type the code on the link you sent me the error stops appearing, but what do I do after I type this there? Screen Shot 2020-06-27 at 2.00.58 PM.png@Subodh_Tiwari_sktneer