Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding first (end of range) empty cell
Hi,
i'd like to know how would it be possible to find the first empty cell in a colum (after a range of values, ie bottom example), with having a static row value (this sheet would have variable numbers of rows). The column would be static. ex : In this case id like to know the address A4, reminder, there might be more rows or less, depending on the file. a b c d 1 X X X X 2 X X X X 3 X X X X 4 Thank you for your answer, in advance Alex |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding first (end of range) empty cell
Alex
Try the following to get you started Sub Find_Address() 'range("a3")=start of the column you want to find the address on lastcell = Range("a3").End(xlDown).Offset(1, 0).Address '.Select MsgBox lastcell End Sub "Alesandro Senerchia" wrote in message ... Hi, i'd like to know how would it be possible to find the first empty cell in a colum (after a range of values, ie bottom example), with having a static row value (this sheet would have variable numbers of rows). The column would be static. ex : In this case id like to know the address A4, reminder, there might be more rows or less, depending on the file. a b c d 1 X X X X 2 X X X X 3 X X X X 4 Thank you for your answer, in advance Alex |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding first (end of range) empty cell
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding first (end of range) empty cell
Yep ... second time it's happened this month. Don't know why. Fixed now,
thanks. Regards, Vasant. "Don Guillett" wrote in message ... Vasant, Is you system date off? -- Don Guillett SalesAid Software "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Range("A" & Rows.Count).End(xlUp).Offset(1).Address -- Vasant "Alesandro Senerchia" wrote in message ... Hi, i'd like to know how would it be possible to find the first empty cell in a colum (after a range of values, ie bottom example), with having a static row value (this sheet would have variable numbers of rows). The column would be static. ex : In this case id like to know the address A4, reminder, there might be more rows or less, depending on the file. a b c d 1 X X X X 2 X X X X 3 X X X X 4 Thank you for your answer, in advance Alex |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding first (end of range) empty cell
Range("A" & Rows.Count).End(xlUp).Offset(1).Address
-- Vasant "Alesandro Senerchia" wrote in message ... Hi, i'd like to know how would it be possible to find the first empty cell in a colum (after a range of values, ie bottom example), with having a static row value (this sheet would have variable numbers of rows). The column would be static. ex : In this case id like to know the address A4, reminder, there might be more rows or less, depending on the file. a b c d 1 X X X X 2 X X X X 3 X X X X 4 Thank you for your answer, in advance Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
If cell not empty, then display from range | Excel Discussion (Misc queries) | |||
Picking up the last non-empty cell in a given range | Excel Discussion (Misc queries) | |||
Goto next empty cell in a range | Excel Programming |