Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
to find cell
I want to find cell in column A which is blank after the used range i
the sheet like if the used range in sheet 1 ends in A20000, i want to find cel A20001 THANKS A LO -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
to find cell
Dim rng as Range
set rng = ActiveSheet.UsedRange set rng = intersect(rng.EntirRow, Activesheet.Columns(1)).Cells set rng = rng(rng.count+1) or if you mean the next blank cell looking from the bottom set rng = cells(rows.count,1).End(xlup)(2) -- Regards, Tom Ogilvy "vikram " wrote in message ... I want to find cell in column A which is blank after the used range in the sheet like if the used range in sheet 1 ends in A20000, i want to find cell A20001 THANKS A LOT --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
to find cell
Vikram,
Dim LastRow as Integer LastRow=Range("A65536").End(xlUp).Row Cheers, Pete. -----Original Message----- I want to find cell in column A which is blank after the used range in the sheet like if the used range in sheet 1 ends in A20000, i want to find cell A20001 THANKS A LOT --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
use find twice to find cell on a specific row | Excel Programming |