micro for next 30 days filter

[Majid]

Thank you Rod. I am trying to make this VBA macro working but I get the
message as follows: complie error:syntex error
Please advise Thank you

 

[John]

Thank you Rod. I am trying to make this VBA macro working but I get the
message as follows: complie error:syntex error
Please advise Thank you

Majid,
I think Rod is sleeping now (other side of the globe) so I'll respond.
If you are getting a syntax error, the editor should be showing you
which line of the code is at fault. Check that you copied the macro code
correctly. I ran it and it works fine (as I would expect).

Hope this helps.
John
Project MVP

 

[Majid]

Thanks John,
I believe you that it works but I am not able to run it. Perhaps I am doing
somthing wrong? I gave it to IT to help me out.
I let you know the outcome
Regards,
Majid

 

[Earl Lewis]

Majid,

If you're getting a compile error and others are not (i.e. John and Rod) you either don't have all the references required added to your VBE to allow it to compile properly OR you missed one of those line continuations that Rod has in the original routine. Line continuations are underscores and they can trip you up if you aren't careful.

Earl
Thanks John,
I believe you that it works but I am not able to run it. Perhaps I am doing
somthing wrong? I gave it to IT to help me out.
I let you know the outcome
Regards,
Majid