|While Razor2.3's elegant suggestion will work based on the inner workings of VBA, I'd like to explain the use of IsOdd since you asked "Am I misunderstanding the use of the 'IsOdd' instruction?"|
IsOdd is worksheet function not actually "known" to VBA. In order to use certain Excel based functions, you need to use the WorksheetFunction object:
If WorksheetFunction.IsOdd(Sheets("GMPAIRS").Range("J44")) Then
The way your code is written, VBA is seeing IsOdd as a variable. Since it never gets set to anything, it is "empty" and unless J44 is also empty your If will never be True.
If you were to get used to using Option Explicit, which forces you to define your variables, IsOdd would have been highlighted with the message "Variable not defined" when the VBA editor tried to compile your code. At that point you probably would have realized that you were not using IsOdd correctly.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03