Hi,
I am having trouble with this section of code.
What I want is if the active cell contains a "." then go to skippy, but the code goes to it anyway.
I am trying to get the lenght of the activecell - the length of the active cell with no "."'s in it
Can anyone help
I am having trouble with this section of code.
Code:
If Len(ActiveCell.Value) - Len(WorksheetFunction.Substitute(ActiveCell.Value, ".", "")) <> Len(ActiveCell.Value) Then GoTo skippy
What I want is if the active cell contains a "." then go to skippy, but the code goes to it anyway.
I am trying to get the lenght of the activecell - the length of the active cell with no "."'s in it
Can anyone help