Problem Solved for the selection of different Rows..
I just record a Macro and Replace this code
With this Code.
‘select all visable rows
Other Problems were coming due to ref nu was not assigned in some sheets to all rows.. In “Final BOQ Combined Book” I Highlighted with yellow.