Reply To: Reply To: Lesson 2.5 – Prepare B.O.Q ( Combined all BOQ Items in one sheet )

[Muhammad Rehan]

Dear Mr.Hany,

Problem Solved for the selection of different Rows..
I just record a Macro and Replace this code
Range(“A8”).Select
Range(“A8:J8”).Select
Range(Selection, Selection.End(xlDown)).Select

With this Code.
‘select all visable rows
Rows(“2:8335”).Select

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.
Thanks,
Best Regards,
Muhammad Rehan

Attachments:

You must be logged in to view attached files.