Find Matching Characters in Excel 1

[Bass71]

Hi, I'm trying to evaluate the first 5 characters in the activecell and the one right below, but lamentably the debugger doesn't like the <<Cells(2, 1).>> part of the statement.

If Left$(Text$, 5) = Cells(2, 1).Left$(Text$, 5) Then...

Thanks for your help


RO

 

[SkipVought]

hi,

If Left$(Text$, 5) = Left$(Cells(2, 1).Value, 5) Then...

this compare the value in Text$ with the value in Cells(2,1).


Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]

 

[PHV]

the first 5 characters in the activecell and the one right below
If Left(ActiveCell.Text, 5) = Left(ActiveCell.Offset(1, 1).Text, 5) Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886