Unsolicited grey shaded are on the screen
 

Hi,

Not sure which of the XL forums to put this in, so thought i'd start here.
After i run quite a lengthy VBA procuedure, i get a light grey shaded are
appearing from top to bottom on the screen, and covering from left to right
about 10% of the screen.

Course, this might not be an Xl issue, could be Windows issue. Has anyone
ever had this before and if so what (if any) was the solution.

It's intermitent which probably doesnt help!

Thanks

John

Unsolicited grey shaded are on the screen
 

hi john ,

don't know if this helps.
I had the same problem before , but for the moment it seemed to have
stopped.
I had to provide "Option Explicit" at the top and declare all of my
variables , and this for every sheet or module in the Microsoft Visual
Basic Editor.
Until now the problem did not occur anymore.
It sounds stupid , but it helped me.

Maybe other people have other solutions.

MarMo

"John" wrote in message
...
Hi,

Not sure which of the XL forums to put this in, so thought i'd start here.
After i run quite a lengthy VBA procuedure, i get a light grey shaded are
appearing from top to bottom on the screen, and covering from left to
right
about 10% of the screen.

Course, this might not be an Xl issue, could be Windows issue. Has anyone
ever had this before and if so what (if any) was the solution.

It's intermitent which probably doesnt help!

Thanks

John

Unsolicited grey shaded are on the screen
 

Hi Marmo,

Thanks for the suggestion. Ok, i'll give it a go, sounds a wierd potential
solution, but hey if it works!!

John



"MarMo" wrote:

hi john ,

don't know if this helps.
I had the same problem before , but for the moment it seemed to have
stopped.
I had to provide "Option Explicit" at the top and declare all of my
variables , and this for every sheet or module in the Microsoft Visual
Basic Editor.
Until now the problem did not occur anymore.
It sounds stupid , but it helped me.

Maybe other people have other solutions.

MarMo

"John" wrote in message
...
Hi,

Not sure which of the XL forums to put this in, so thought i'd start here.
After i run quite a lengthy VBA procuedure, i get a light grey shaded are
appearing from top to bottom on the screen, and covering from left to
right
about 10% of the screen.

Course, this might not be an Xl issue, could be Windows issue. Has anyone
ever had this before and if so what (if any) was the solution.

It's intermitent which probably doesnt help!

Thanks

John