Hi guys,
I'm creating a .xla file so I can distribute my macro as an add-in to my friends and collegues.
However, the macro doesn't seem to work at all.
I made an .xla file, opened it and it works perfectly.
I can click the buttons I'm supposed to and some of the 'code' seems to run.
But as soon as I call subs, it errors on stuff like:
- Sheets("Sheet").Range("A1:A10000").NumberFormat = "@"
- c (for cell) is an undefined variable
Is this because what I'm trying to do is in a different workbook/project or something?
If I drag the module over to the workbook where the sheets are it crashes too.
I would love to hear what I can do to troubleshoot/figure out what I'm doing wrong.
And please start at the basics, it could be something as silly as not having my monitor plugged in
I'm creating a .xla file so I can distribute my macro as an add-in to my friends and collegues.
However, the macro doesn't seem to work at all.
I made an .xla file, opened it and it works perfectly.
I can click the buttons I'm supposed to and some of the 'code' seems to run.
But as soon as I call subs, it errors on stuff like:
- Sheets("Sheet").Range("A1:A10000").NumberFormat = "@"
- c (for cell) is an undefined variable
Is this because what I'm trying to do is in a different workbook/project or something?
If I drag the module over to the workbook where the sheets are it crashes too.
I would love to hear what I can do to troubleshoot/figure out what I'm doing wrong.
And please start at the basics, it could be something as silly as not having my monitor plugged in
