Refining when a worksheet_Change event runs with perhaps ISodd or similar

Thank you to Bob Phillips for getting me this far.

I am having problems with refining when code runs.

this is the code so far

Please Login or Register  to view this content.

Whilst this code works perfectly it does not give me the flexibility of being able to be more specific as to when it runs

I can place a marker in a column (at row 8 for example) which i will simply hide by making it the same colour as its background.
then the code needs to run only when the row is an odd value ant within a certain range (eg from 9 to 21)
I suspect i need to use the Isodd or iseven syntax but i am struggling as to how

This or a very similar post has been placed in Mr Excel also but i seem to be unable to access their site cureently so i am unable to link (currently)

As i am TRYING (slowly) to learn as i go PLEASE rather than just fix my issue notate things and hopefully one day i will be more capable.

Thank you in advance

Rather than saying:

Please Login or Register  to view this content.

with your code within the IF/END IF block, use:

Please Login or Register  to view this content.

Then you can also use:

Please Login or Register  to view this content.

*However*, don't put:

Please Login or Register  to view this content.

at the beginning of your code. Put it just prior to where you will make a change to the sheet, thus potentially firing the Change event again.

Not sure about the last point ;-(

However, based on these suggestions, your code becomes:

Please Login or Register  to view this content.

Regards

There is no ISODD in VBA, you need something like

Please Login or Register  to view this content.

Thank you both i am however confused or more likely stupid

Originally Posted by royUK

There is no ISODD in VBA,

you state the above however TMShucks writes

Please Login or Register  to view this content.

There is something i am not grasping

Please ignore my last , i think im getting there .... onward and again thanks

RoyUK is correct. There isn't an IsOdd() function in VBA. I think TMShucks assumed that you had written your own IsOdd() function.

The quickest way to check if an integer, x, is odd is to use this expression:

Please Login or Register  to view this content.

If you want, you can then wrap it in a function called IsOdd() like this:

Please Login or Register  to view this content.

Thinking about it you could use

Please Login or Register  to view this content.

Thank you everyone , the beauty of forums is combined effort .
One day i strive to be the geniuses you guys obviously are - ( but im a realist )

I'm not thick but VBA makes me doubt it :-)

IsOdd isn't a "function" that I have used. As it was there, I assumed it was valid but I had nothing to test the code with so I just massaged it as it was.

@Wobbles: thanks for the rep

Regards