Find Cell

[Parra]

This has to do with my earlier post which Al helped me with but I have one small problem.

The macro looks for a cell with only the word Total in it, my problem is that Total is the last word in the following options.

City Total
State Total
Zip Code Total

How would I change the command below to select any of the 3 words which all contain the word Total?

If (cell.Value) = "Total" Then

Thanks

[Al Chara]

Use:
If right(cell.Value,5) = "Total" Then


_________________
Hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-04-17 15:37 ]

[Yogi Anand]

On 2002-04-17 15:32, Parra wrote:
This has to do with my earlier post which Al helped me with but I have one small problem.

The macro looks for a cell with only the word Total in it, my problem is that Total is the last word in the following options.

City Total
State Total
Zip Code Total

How would I change the command below to select any of the 3 words which all contain the word Total?

If (cell.Value) = "Total" Then

Thanks

You could use the lookup value to be

=right(CellName,5) to pick up Total that consists of 5 characters in the extreme right location in that cell!

[Yogi Anand]

Sorry, Al:
I did not see your post ... mine probably went in right after yours!

[Parra]

Yeah! Thats exactly what I needed it to do.

Al, Thanks a lot