Unsolicited grey shaded are on the screen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Hi Marmo,

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

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grey are covering 10% or so of the screen from left to righ 1
Fill color palette remain on screen 2
Laserjet print quality on large grey shaded areas 8
How Do You Re-Create Multi-Shaded Form Headers/Footers 1
Is there a formula, function or macro that accounts for shading of a cell or row? 1
'close group' options greyed out 0
Shading Title at top of page 7
Position screen at end of macro 3

Back
Top