Dear Mr.Hany,
‘select all visable rows
Range(“A8”).Select
Range(“A8:J8”).Select
Range(Selection, Selection.End(xlDown)).Select
The code given above just selecting the required data which are coming at exact A8 row, but if first row is other than A8 then it is selecting only one row out of all rows for a given sheet.
so how we can select data with different rows.. i.e Apt A4 have visible data in A7 row..
Waiting for your reply.
Thanks.
Regards,
Muhammad Rehan