I am having a problem using the left function to check for spaces at the beginning of a string. using this code:
If Left(ActiveCell, 5) = " " Then activecell.offset(1,0).activate
I am trying to skip any string that begins with 5 spaces. The code above does not seem to work to accomplish this goal. Does anyone have any suggestions about how to better go about this?
If Left(ActiveCell, 5) = " " Then activecell.offset(1,0).activate
I am trying to skip any string that begins with 5 spaces. The code above does not seem to work to accomplish this goal. Does anyone have any suggestions about how to better go about this?