Can I Select Specific Cells Or Ranges. You can also select named or unnamed cells or ranges by using the Go To F5 or CtrlG command. Instead of EntireRow use EntireColumn along with the Range or Cells Objects to select entire columns.
Range A1 C1 E1Select You can also select sets of non-contiguous ranges in VBA. You can do this with either of the following options1 X Research source. Select any cell in the range or the whole range and click Insert Table or hit Ctrl-T.
Lets say you want to select cell E6 with Visual Basic.
You can get it done as follows. Perhaps the easiest but not necessarily the most efficient way to select a cell or range uses the Range objects Select method in the following form. Selecting multiple rows or columns works exactly the same when using EntireRow or EntireColumn. To lock cells or ranges select them in a usual way by using the mouse or arrow keys in combination with Shift.