Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Help with using range names in sum function | Excel Worksheet Functions |