Dear friends
Please help me how to change the line .................>>>>>>>>>
With WB.Sheets(WS.Name).Range("D:E")
With WB.Sheets(WS.Name).Range(rngsearch.name)
Thanking you in advance
I change different methods...... like
Dim rngsearch as range
set rngsearch = .range(rngsearch.name)
basically i add this name range instead of .Range("D:E") manually, but code not work properly.
Please Login or Register to view this content.
Bookmarks