Running a certain Macro results in a ghost image of another sheet

**XenoThorn** · 02-20-2015, 11:51 AM

Hi All,

I'm hoping someone can help me with this, I've created a Spreadsheet which is used for recording an inventory of items we purchase at work which has developed a random problem when I've been entering data.

Basically when ever i run my macro it creates an image of a part of the previous sheet over the top of my current sheet this can be removed by scrolling or changing tab and changing back, so it appears temporary like a ghost image

Thanks any helps appreciated?

**walruseggman** · 02-20-2015, 12:18 PM

Try adding these as the first and last lines of code in your sub, respectively.

Please Login or Register  to view this content.

**XenoThorn** · 03-03-2015, 09:34 AM

thanks for the suggestion but i have already tried those two pieces of code and it actually does help slighlty as the overlay takes a little while longer to reappear but still doesnt fix the problem

Update I tried that code again and it now works properly however whenever i delete the cells the macros writes it now brings up the ghost overlay there instead