Trouble with macro - Loop through all work sheets

Good Morning,

Having a bit of trouble trying to get this macro to work for every sheet.

Can't seem to get it to loop through all of them.

I think its something to do with the active sheet line veing wrong for what I'm trying. Any any ideas? Any help will be greatly appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Still now working I'm afraid. It just runs for the active page.

Rich Tea,
When you run the macro, does it loop through each WS1?

Please Login or Register  to view this content.

Actually,

It is looping through the pages, but it's not creating the appointments, just putting today's date into the 'check' cells. Any idea's why it wouldnt be creating the appointments?

Still Not got this working yet, any clues why it wouldn't be creating the appointments?

RichTea,
Sorry! I am unble to test your code as I do no have outlook setup on my Laptop

Ah That's no worries AB33. Thanks for your help so far anyways!

I'm sure someone will spy whats wrong evenutally. Always find problems most difficult to solve when it's almost working but not quite!

Sorry,

Still trying to get some idea's on this one

Come on guys I know theres some whiz kid out there who can crack this problem with just a glance!

Okay, so this is what seems to be happening.

It loops fine for the due appointments on the active page, if theres more than one on the same page it creates an appointment for each.

However, it won't create appointments due on other sheets within the workbook, but it does loop through them and return a date value.

Can anyone give me any idea why it does this?

Okay, so this is what seems to be happening.

It loops fine for the due appointments on the active page, if theres more than one on the same page it creates an appointment for each.

However, it won't create appointments due on other sheets within the workbook, but it does loop through them and return a date value.

Can anyone give me any idea why it does this?

Norie, You Sir are a gentleman and a scholar.

You're the Whiz Kid I was speaking about!

Many thanks for your help!

R