| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find last row with data
I have an excel file that is looking at another file to get an array of info.Currently it is going to the first blank row then looking up one row and retrieving that info.I have pasted below the function as it is currently written .Can someone show me an editing of this that will tell it to simply read the bottom row with data. Thankss-Greg Function FindBlankRow() x = 2 Do While ActiveSheet.Cells(x, 1) < "" x = x + 1 Loop FindBlankRow = x - 1 -- singlgl1 ------------------------------------------------------------------------ singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389 View this thread: http://www.excelforum.com/showthread...hreadid=488238 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To find equation for two sets of non contiguous data | Charts and Charting in Excel | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
| "Link to other data source" - How can I find out what is linked? | Excel Discussion (Misc queries) | |||
| How do I find an unknown value on a line made from known data? | Excel Discussion (Misc queries) | |||
Threaded Mode
