Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get reference to a range as string?
I can get a reference to a cell as string with function CELL("address",
A1), which will return the string $A$1. How do I get a reference to a range, for instance, A1:A5? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get reference to a range as string?
Assuming you're taking about macros...
selection.address or range("A1:A5").address would produce a string of $A$1:$A$5. HTH, Gary Brown " wrote: I can get a reference to a cell as string with function CELL("address", A1), which will return the string $A$1. How do I get a reference to a range, for instance, A1:A5? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get reference to a range as string?
Thanks. I'm actualy writing it as a function, say Addr(range). It works
only for the range in the current sheet. If I enter Addr(Sheet2!A1:A5) on a cell in Sheet1 , range.address only returns $A$1:$A$5 without the sheet name. How do I write the Addr() so it adds the sheetname! only if the input range is on another sheet. Function Addr(r As Range) Addr = r.Address End Function |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get reference to a range as string?
Function addr(r As Range) As String
Application.Volatile If ActiveSheet.Name < r.Worksheet.Name Then addr = r.Worksheet.Name & "!" & r.Address Else addr = r.Address End If End Function hth, Gary Brown " wrote: Thanks. I'm actualy writing it as a function, say Addr(range). It works only for the range in the current sheet. If I enter Addr(Sheet2!A1:A5) on a cell in Sheet1 , range.address only returns $A$1:$A$5 without the sheet name. How do I write the Addr() so it adds the sheetname! only if the input range is on another sheet. Function Addr(r As Range) Addr = r.Address End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I show a reference value with a string? | Excel Discussion (Misc queries) | |||
reference to a cell within a string | Excel Programming | |||
Translate range name passed as string to a custom function to range addresses! | Excel Programming | |||
Passing a String in Array to Range as String | Excel Programming | |||
Setting named range in VBA- how to set as formula/reference instead of text string? | Excel Programming |