Help incorporating sheet name (which is a number) into a very basic maths equation

Hello

I have set up my work book so that the sheet names are number, I wish to do some basic maths where upon the sheet names (which are numbers) are incorporated in some basic calculations.

My knowledge of excel is fairly basic however I have roughed out a concept map below of what I would like to achieve.

I suspect that I may need to Dim the sheet names (under the sheet heading) as integers or some other term to let excel know that these values are numbers.

The reason behind my attempt to write this code is to use the active sheet name to reference a cell location on a work sheet called "Index". This piece of code will be replicated on a number of different sheets.

For the sake of this post lets just say I wish to set the cell location to TRUE.

For the sake of this post lets say the Sheet name is currently "1"

The mathematical relationship is that if you take the active sheet name and add this value to itself, then add a 1 to this value this will be the row number to be referenced.

Please Login or Register  to view this content.

Any assistance is greatly appreciated, in the past I have been highly impressed and very thankful with the assistance I have received on this forum.

Regards,

Michael Surace.