Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
last row value in a range
Hi
Have a userform in this form i have a textfield i want to take the last row with value from a sheet into this field regards alvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
last row value in a range
I have done it
alvin "Alvin Hansen" skrev: Hi Have a userform in this form i have a textfield i want to take the last row with value from a sheet into this field regards alvin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
last row value in a range
Hello Alvin, Here is an example. The data is in column "A" on "Sheet1". The TextBo on the UserForm is TextBox1. LastRow = Application.WorksheetFunction.CountA("A:A") TextBox1.Text = Sheets("Sheet1").Cells(LastRow, 1) __________________________________________________ _______________ The CountA function counts any type of information, including empt text ("") but not including empty cells. If an argument is an array o reference, empty cells within the array or reference are ignored. I you do not need to count logical values, text, or error values, use th COUNT function. Also, when changing your column from "A" to whatever, Cells functio reference is Cells(Row, Column). __________________________________________________ _______________ Hope this helps, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=34585 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |