Hi Don-

Thanks for your quick response. I find I didn't quite size up the problem
correctly.
The second macro does find the correct column.(Column 48).
But it runs the Check.EntireRow.copy regardless whether the column 48 value
is true or false.

If Check = "True" Then
Check.EntireRow.Copy


Thanks much!