In a macro, if I wanted to select all cells from A1 to F8, I would use
Range ("A1:F8").select. If I were to use an input box to have the user input the location of the last cell to select (for example:
LastC=inputbox("Enter Last Cell to be selected") , What is the syntax of the Range command to allow me to select these cells starting at A1?