Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
First and Last cell of a named range
Hello,
How do you determine what the first and last cell of a named range and get its value? Can you use the offset function with this? -- Thanks in advance, Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
First and Last cell of a named range
Steven,
If your named range is named "MyRange" then this is one way... '------------------------------- Sub GetNamedRangeValues() Dim x As Long Dim y As Variant x = Range("MyRange").Count y = "Last cell value is " & Range("MyRange")(x).Value MsgBox y y = Range("MyRange")(1).Value MsgBox "First cell value is " & y End Sub '----------------------------------- Regards, Jim Cone San Francisco, CA "Steven K" wrote in message ... Hello, How do you determine what the first and last cell of a named range and get its value? Can you use the offset function with this? Thanks in advance, Steven |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
First and Last cell of a named range
Hi Steven,
Assuming that the named range is a single area range: Sub Tester03() Dim Rng As Range Dim FirstCell As Range, LastCell As Range Set Rng = Range("A1:H2") Set FirstCell = Rng(1) Set LastCell = Rng(Rng.Count) 'Return address and values of first and last cells MsgBox "The first cell (" & FirstCell.Address & ") = " _ & FirstCell.value & vbNewLine & _ "The last cell (" & LastCell.Address _ & ") = " & LastCell.value End Sub --- Regards, Norman "Steven K" wrote in message ... Hello, How do you determine what the first and last cell of a named range and get its value? Can you use the offset function with this? -- Thanks in advance, Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference first cell in a named range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
named cell range | Excel Worksheet Functions | |||
Getting a named range from a cell value | Excel Worksheet Functions |