Check worksheet called 'End' is actually at the end

**TheRobsterUK** · 05-30-2014, 06:45 AM

I have a spreadsheet that can have anywhere between 500-1000 worksheets but the final sheet is always one called 'End'. Since other people use the spreadsheet and lots of data is imported/exported, sometimes 'End' gets moved. I need a macro that can check the relative location of End and make sure it is where it's supposed to be.

I thought something along the lines of: count number of worksheets in workbook. Get relative position of End. If these two match, okay, if not then End is not where it's supposed to be. I only know how to count the worksheets though, i.e.

Please Login or Register  to view this content.

Bit stuck with how to return the position of a specific worksheet however...

Cheers
Rob

**nathansav** · 05-30-2014, 06:48 AM

Please Login or Register  to view this content.

Not tested.

**haripopuri** · 05-30-2014, 06:52 AM

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 05-30-2014, 07:03 AM

Maybe:

Please Login or Register  to view this content.

**TheRobsterUK** · 05-30-2014, 09:39 AM

Thanks all. :-)

Rob

Check worksheet called 'End' is actually at the end

LinkBack

Thread Tools

Rate This Thread

Display

Check worksheet called 'End' is actually at the end

Re: Check worksheet called 'End' is actually at the end

Re: Check worksheet called 'End' is actually at the end

Re: Check worksheet called 'End' is actually at the end

Re: Check worksheet called 'End' is actually at the end

Thread Information

Users Browsing this Thread

Similar Threads

Can a Function( ) called from within worksheet write to another cell?

[SOLVED] How to reference the name of the module in which a function is called in a worksheet

save active worksheet in directory called in another worksheet cell

code called from module check first data only not all of them

Determine Which Check Box Called Procedure

Bookmarks

Bookmarks

Posting Permissions