| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to identify the start and end of range
Sub a()
Dim Rg As Range Dim StringRg As String StringRg = "TaxData!$B$4:$G$18" Set Rg = Range(StringRg) Debug.Print "Start row: "; Rg.Row Debug.Print "Start col: "; Rg.Column Debug.Print "End row: "; Rg.Row + Rg.Rows.Count - 1 Debug.Print "End col: "; Rg.Column + Rg.Columns.Count - 1 End Sub -- Jim Rech Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify a range of cells containing dates | Excel Worksheet Functions | |||
| Identify peaks and troughs in range | Excel Discussion (Misc queries) | |||
| VBA, identify a range | Excel Worksheet Functions | |||
| Identify User Selected Range | Excel Programming | |||
| Identify Range Selected By User | Excel Programming | |||
Threaded Mode
