I am having a problem with a macro that I am writing. Everytime I try
to run it it gives me an error. I think I can fix it using global
variables. But now I keep getting an error saying invalid attribute. I
have tried setting all variables = 0 then running it. Please help!!!!

Give us more details on the error and when it happens.
AFAIK, there is limit of 64K (?) for the amount of code contained in a
single module, although I see no reason to ever get that large. Split it
into routines (sub/function) in modules/classes.
How large is your code ? Right-click on the moduleExport, save somewhere
suitable and check the size of the resultant file.

NickHK

wrote in message
ups.com...
I am having a problem with a macro that I am writing. Everytime I try
to run it it gives me an error. I think I can fix it using global
variables. But now I keep getting an error saying invalid attribute. I
have tried setting all variables = 0 then running it. Please help!!!!

You can try debugging your code and setting thru the program.

Some simple solutions are to use option explicit to check al lthe variables
are spelt correctly.

Generally attributes refer to incorrect items in function or procedure calls.

Check the line where your code breaks down and make sure the code is correct.

Do this with clicking debug and see where you are.


--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


" wrote:

I am having a problem with a macro that I am writing. Everytime I try
to run it it gives me an error. I think I can fix it using global
variables. But now I keep getting an error saying invalid attribute. I
have tried setting all variables = 0 then running it. Please help!!!!