Addin Help

[vmadan16]

Hi All,

I created a macro and saved it as a ".xla". The macro selects sheet7 and updates few values and selectes sheet6 and updates few values.

I have used code:

Please Login or Register  to view this content.

when I install the addin and run it in diffrent workbook it give me the below error.

Run-time error '424'
Object required

please help me out with this.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time, but make sure you read & understand the Forum Rules

[Andy Pope]

The code will error if the active workbook does not have Sheet6. As your reference is not specific to the addin.

looks like we were both adding code tags Roy

[royUK]

Hi Andy, that locked up my post completely I had to re-open the forum.

[Andy Pope]

Sorry about that.

[vmadan16]

Sorry for not adding the tags. will do it hence forth.

I have around 15 sheets in that workbook and I have a variable which stores the active workbook which shows correctly but still I am getting the error.

[royUK]

As Andy says the way your code is written the addin is looking for Sheet6 in the addin, you must reference the correct workbook using either ActiveWorkBook or your variable

Please Login or Register  to view this content.

You should also remember it is generally unnecessary to activate/select sheets or ranges in VBA.