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?
Hello Nebb,
Use this code. LastC needs to be a string, and must be a single cell reference like "A1".
Sincerely,
Range("A1", LastC).Select
Leith Ross
My thanks to Leith for his reply. His suggestion does work. However, it presents me with another question. If I use the following code:
Dim LastC As String
LastC = InputBox("Enter last cell location")
Range("a1", LastC).Select
The code works perfectly and the cells are properly selected. If, however, the code reads:
I get a Run Time error '1004'Dim LastC As String LastC = F10 Range("a1", LastC).Select
Method 'Range' of object '_global' failed
What should I have entered to prevent this run time error?
Last edited by mudraker; 08-11-2007 at 06:44 PM.
Hello Nebb,
The argument required by the Range Object is a String. Enclose F10 in quotes...
Sincerely,Dim LastC As String LastC = "F10" Range("a1", LastC).Select
Leith Ross
Thank you Leith. That did the job.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
nebb 
Register To Reply
Bookmarks