| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find
does anyone know of a way to find the last row in an excel worksheet that does data and set the cursor to the next empty cell -- joi2 ------------------------------------------------------------------------ joi2's Profile: http://www.excelforum.com/member.php...o&userid=27554 View this thread: http://www.excelforum.com/showthread...hreadid=486948 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find
Try something like the following:
Cells(Rows.Count, "A").End(xlUp)(2, 1).Select -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "joi2" wrote in message ... does anyone know of a way to find the last row in an excel worksheet that does data and set the cursor to the next empty cell -- joi2 ------------------------------------------------------------------------ joi2's Profile: http://www.excelforum.com/member.php...o&userid=27554 View this thread: http://www.excelforum.com/showthread...hreadid=486948 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find
well I'M not sure whats goin to be in the cell so I dont think "A" is going to work -- joi2 ------------------------------------------------------------------------ joi2's Profile: http://www.excelforum.com/member.php...o&userid=27554 View this thread: http://www.excelforum.com/showthread...hreadid=486948 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find
An alternative to using the "End" functions, especially if the data area is
not nice and square. with ws 'ws = Worksheet object lastrow = .Cells.Find(What:="*", SearchDirection:=xlPrevious, _ SearchOrder:=xlByRows).Row lastcol = .Cells.Find(What:="*", SearchDirection:=xlPrevious, _ SearchOrder:=xlByColumns).Column End With Set LastCell = ws.Cells(lastrow, lastcol) In my experimentation, this is not as efficient as using the "End" method, but it does find the very last cell of all "shapes" of data areas. "joi2" wrote: well I'M not sure whats goin to be in the cell so I dont think "A" is going to work -- joi2 ------------------------------------------------------------------------ joi2's Profile: http://www.excelforum.com/member.php...o&userid=27554 View this thread: http://www.excelforum.com/showthread...hreadid=486948 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
| find and delete text, find a 10-digit number and put it in a textbox | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
![joi2[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
