Loop through sheets to gather info on first sheet

[amphinomos]

Hi,

I've started building a macro that loops the sheets and collects the information onto the first worksheet. I've been using Activesheet and activecell references but i'm afraid looping will change these references. Any help would be great.

Please Login or Register  to view this content.

[amphinomos]

This macro is far from perfect but it turns out that it works. I thought that the loop would change the activesheet to the sheet currently in the loop but it doesn't