| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column and row references of range
Michael Allen wrote:
Is is possible to determine the extent column and row references of a temporarily selected ranges of cells in code, ie top left and bottom right? Cells within the range may contain blanks. Thanks Mike Set rng = Range("aaa1") MsgBox rng(1, 1).Address & ":" & rng(rng.Rows.Count, _ rng.Columns.Count).Address Alan Beban |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column and row references of range
Is is possible to determine the extent column and row references of a
temporarily selected ranges of cells in code, ie top left and bottom right? Cells within the range may contain blanks. Thanks Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change column references, while filling down another column | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Subtotal Range of Alphanumeric References | Excel Worksheet Functions | |||
| Narrow the range a Sumif references | Excel Programming | |||
| Bracketed Range References | Excel Programming | |||
![Alan Beban[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
