Search for the first character in an excel field with VBA

[rjmccafferty1]

Within an Excel macro, I want to check if the first letter of a cell entry is the letter z in small case.

I tried:
If Left(activecell.offset(-1,5).characters.value,1)="z" Then
But this returns an error.

Following the pattern of someone's answer on a different help site, I then tried to just go to the cell and use the following code:
If Left(activecell.characters.value,1)="z" Then
But again I got an error message.

How can I check to see if the first letter of an entry begins with the letter "z" within an Exel macro as the condition of an if statement?

 

[SkipVought]

Hi,

So you are not testing the ActiveCell, but the cell ON ROW ABOVE and FIVE COLUMNS TO THE RIGHT of the Activecell?

If LCase(Left(activecell.offset(-1,5).value,1))="z" Then
...

of course if your ActiveCell is in ROW 1, TILT!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[rjmccafferty1]

I've got it. The macro designates the starting cell before the rest of the code runs, so there is no issue about being in row 1. Thank you for the response.

 

[SkipVought]

The macro designates the starting cell ...

If that's the case, then there is probably no need for Selecting or ActiveCell in your macro.

Post your entire code for tips.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}