Solved: ScreenUpdating Issue?

[jmenche]

Howdy,

I have a routine that takes a data set on one sheet and copies some of it to another part of the same sheet and then eventually hides the columns. I turned off screenupdating but you can still see Excel whip around the sheet. Is there any way to not have this happen? Is screenupdating only for multiple sheets?

[tpoynton]

any chance of posting the offending code? setting application.screenupdating to false should turn it off...

[jmenche]

ooops...i found the issue...another routine that i was calling was turning it back on ;-)

[Aussiebear]

any chance of posting the offending code?

I don't mean to be critical here, but this is an example of not helping the VBA challenged people catchup with the subject matter. For the experienced people, I guess you learn to live with questions about code not working, and can visualise what the person making the post actually wants.

There is another group of us out here who are wanting to learn, to see examples of code would be very helpful but if somone just suggests they have found the solution and we don't get to see it.... well we might as well go bang heads against the wall.

All I ask is that in these circumstances, can the corrected code be displayed...please?

[Bob Phillips]

the before and after, so the error can be seen.

[Aussiebear]

I agree Bob, now it might mean that for a moment in time the poster might feel slightly embarrassed, but when looking at the overall picture, its a learning curve for all of us.

And that's what we are here for aren't we?

[jmenche]

Believe it or not, I am one of you!

However, in this instance I found out my problem before I needed the answer. I was calling another routine that was undoing what I wanted done. Also, I often ask conceptual questions versus purely syntaxtual (i hope that's a word). Sometimes the code can be a distraction.

[rory]

it's syntactic or syntactical