| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help to find the last row of data
Hello
I need someone to help me to write a macro to find the last row in my data. I will have two columns A & B with text in it. Suppose I have data in 5 row, 6th row will be empty. When I run the macro I want the data to be selected A1:B5. If I enter another item in my data and run the macro, it should select A1:B6. That is the first step, then I want the data to be sorted on Column A. I hope this is clear . I am desperately looking someone to help me. Thanking you GT --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
| Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
| FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?) | Excel Worksheet Functions | |||
![gmangad[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
