Range
I want to take a range that I have inputted from a input box and get
row ID numbers. the range is written as follows:
Set myRng = Nothing
On Error Resume Next
Set myRng = Application.InputBox(Prompt:="Select a range!", Type:=8)
On Error GoTo 0
If myRng Is Nothing Then
'user hit cancel
Else
MsgBox myRng.Address
End If
I want to take this range and identify the first and last row number
(actual row ID in excel).
I am having trouble with invalid code when I make variables to identify
this. This is going into a For statement to run code from.
|