| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the last row
Hi there, I need to find the last row with data on it.... does anyone have the VB to do so...? Thanks and regards D *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find the last row
LastRow = Cells(Rows.Count,"A").End(xlUp).Row -- HTH Bob Phillips "Darin Kramer" wrote in message ... Hi there, I need to find the last row with data on it.... does anyone have the VB to do so...? Thanks and regards D *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find the last row
Thanks Bob, sorry I was not specific enough in my query. I want to find the last row of text, and then select everything between that row and cell a1, copy and paste it into a new sheet. Regards D *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find the last row
Just column A?
Range("A1").Resize(Cells(Rows.Count,"A").End(xlUp) .Row).Copy Worksheets("Sheet2").Range("A1") -- HTH Bob Phillips "Darin Kramer" wrote in message ... Thanks Bob, sorry I was not specific enough in my query. I want to find the last row of text, and then select everything between that row and cell a1, copy and paste it into a new sheet. Regards D *** Sent via Developersdex http://www.developersdex.com *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find the last row
Darin Kramer wrote:
Thanks Bob, sorry I was not specific enough in my query. I want to find the last row of text, and then select everything between that row and cell a1, copy and paste it into a new sheet. i use: ActiveSheet.UsedRange.Copy This will copy everything from a1 to the last row and column that is used. hth, damo |
| 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 | |||
Hybrid Mode
