How to read the entire row within a range in excel

Create a new topic for this queries. I think this is out of topic @Kuro