Hi there- In VBA for excel selecting a range can be done in many different ways. Like if you want to select a cell a1 then the code is Range("a1").select. If you want to select a group of cells like say cells starting from a1 to a10 then the code would be Range("a1","a10").select. Although this can also be written as Range("a1:a10").select. Now this was for a continuous range of data but if you want non continuous range to select then we can use something like this Range("a1,a3,a10,c10").select. Finally if you like to select the entire sheet cells then the syntax you can use is cells.select.

Well if you guys know you can contribute the code to select a row, column, multiple rows, multiple column and so on...