Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return value from first row
Does anybody know how to return the value (maybe in a msgBox) from first row in the column where the curser is placed ? If I use "activecell.End(xlUp).value" then it will not go all the way to the top if there is some blank cell.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return value from first row
Kent,
If you really want row 1, use MsgBox ActiveSheet.Cells(1, ActiveCell.Column).Value If you want the first cell in the column containing data, use Dim R As Range Set R = ActiveSheet.Cells(1, ActiveCell.Column) If R.Value = "" Then Set R = R.End(xlDown) End If MsgBox R.Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Kent" wrote in message ... Does anybody know how to return the value (maybe in a msgBox) from first row in the column where the curser is placed ? If I use "activecell.End(xlUp).value" then it will not go all the way to the top if there is some blank cell. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return value from first row
Cells(1,activecell.column).select
for first row cells(1,activecell.column).end(xldown).select for first row with data -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kent" wrote in message ... Does anybody know how to return the value (maybe in a msgBox) from first row in the column where the curser is placed ? If I use "activecell.End(xlUp).value" then it will not go all the way to the top if there is some blank cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return date if in range, else return blank | Excel Worksheet Functions | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
VBA Syntax for VLOOKUP to return array of return values | Excel Programming |