Wow this is good , manage to get it , but somehow because the range thatI want to copy got a link and formula that being hide , it still carrythe whole range , any ideas how to avoid this ?