Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the last used Row on a Worksheet
Hi Experts Is it possible for me to select the blank row immediately after th last used row? I am trying to do something like this, but it's no working: Code ------------------- lastrow = Cells(Rows.count, "B").End(xlUp).Row lastrow2 = lastrow + 2 Range("A65536").End(xlToRight).Select = "lastrow2" OR Range("lastrow2").End(xlToRight).Select ------------------- Kind Regard -- popp ----------------------------------------------------------------------- poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145 View this thread: http://www.excelforum.com/showthread.php?threadid=32006 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the last used Row on a Worksheet
The UsedRange property of the worksheet will get it for you:
LastRow = Worksheets(SheetName).UsedRange.Rows.Count (this gives the last used row, the blank row would be this plus one) "poppy" wrote: Hi Experts Is it possible for me to select the blank row immediately after the last used row? I am trying to do something like this, but it's not working: Code: -------------------- lastrow = Cells(Rows.count, "B").End(xlUp).Row lastrow2 = lastrow + 2 Range("A65536").End(xlToRight).Select = "lastrow2" OR Range("lastrow2").End(xlToRight).Select -------------------- Kind Regards -- poppy ------------------------------------------------------------------------ poppy's Profile: http://www.excelforum.com/member.php...o&userid=11453 View this thread: http://www.excelforum.com/showthread...hreadid=320060 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the last used Row on a Worksheet
lastrow = Cells(Rows.Count, "B").End(xlUp).Row
Range("B" & lastrow+1).Value = "lastrow2" -- HTH RP (remove nothere from the email address if mailing direct) "poppy" wrote in message ... Hi Experts Is it possible for me to select the blank row immediately after the last used row? I am trying to do something like this, but it's not working: Code: -------------------- lastrow = Cells(Rows.count, "B").End(xlUp).Row lastrow2 = lastrow + 2 Range("A65536").End(xlToRight).Select = "lastrow2" OR Range("lastrow2").End(xlToRight).Select -------------------- Kind Regards -- poppy ------------------------------------------------------------------------ poppy's Profile: http://www.excelforum.com/member.php...o&userid=11453 View this thread: http://www.excelforum.com/showthread...hreadid=320060 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the last used Row on a Worksheet
Hi K Dales
This is only working if you have data in the first row of your sheet You can use this to find the last row with data Firstrow = ActiveSheet.UsedRange.Cells(1).Row Lastrow = ActiveSheet.UsedRange.Rows.Count + Firstrow - 1 -- Regards Ron de Bruin http://www.rondebruin.nl "K Dales" wrote in message ... The UsedRange property of the worksheet will get it for you: LastRow = Worksheets(SheetName).UsedRange.Rows.Count (this gives the last used row, the blank row would be this plus one) "poppy" wrote: Hi Experts Is it possible for me to select the blank row immediately after the last used row? I am trying to do something like this, but it's not working: Code: -------------------- lastrow = Cells(Rows.count, "B").End(xlUp).Row lastrow2 = lastrow + 2 Range("A65536").End(xlToRight).Select = "lastrow2" OR Range("lastrow2").End(xlToRight).Select -------------------- Kind Regards -- poppy ------------------------------------------------------------------------ poppy's Profile: http://www.excelforum.com/member.php...o&userid=11453 View this thread: http://www.excelforum.com/showthread...hreadid=320060 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the last used Row on a Worksheet
Hi Experts Thanx for all the quick responses. Got it working. Kind Regard -- popp ----------------------------------------------------------------------- poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145 View this thread: http://www.excelforum.com/showthread.php?threadid=32006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find and unlink current worksheet from old worksheet | Excel Discussion (Misc queries) | |||
Find worksheet | Excel Discussion (Misc queries) | |||
Find Max Value in WorkSheet | Excel Worksheet Functions | |||
Find a worksheet | Excel Programming | |||
find last row on a worksheet | Excel Programming |