I have new question here..
Please see my below code..
In red line code, I want to use Sheet2 now..How do i edit this..can any help..
Dim FndTxt As Range, zVal As Range, Fnd As Long
Set FndTxt = Range("AA3")
For Each zVal In Range("Z501", Range("Z" & Rows.Count).End(xlUp))
**** =...