Input Box to allow a user to choose a cell to delete
Posted by Kurt on July 19, 2000 7:42 AM
I am trying to write a routine that will allow a user to input a cell that they wantto delete. Here's the code I have so far:
Const strTaskName = "Cell to Delete"
'Dim strEnterCell As String
strEnterCell = InputBox(prompt:="Enter the cell you want to delete " & _
"in R1C1 format:", _
I keep bombing on the Range(TaskName).Select line.
Help and thanks!!!