macro that loops through a given range of sheets is freezing

[bkwins]

I got a similar macro off a forum and adjusted it for my needs. When I first ran it it worked but then crashed excel and I had to go looking for the macro again because I hadn't saved it. Now I must have entered it different because it doesn't work but just freezes excel. I am using Excel 97.
Also what can I add to make it select a blank cell like "K9" before it loops on to the next sheet. The usual code to do that isn't working.

Please Login or Register  to view this content.

Here is the macro

Please Login or Register  to view this content.

[AlvaroSiza]

Hi Yin,

You are copying a range and then immediately pasting that range to the same (range) location. This schema then continues @ Range("B6:G39") for each ws.

~as