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
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