Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have column F that the data starts in F5 to F?
I want the last row number. All these examples return F5, one errors out. I can't believe I don't have an example in cheat sheet. Thanks. Howard lrC = Sheets("Data").Cells(Rows.Count, 6).End(xlUp).Row lrC = Range("F5:F" & Range("F5").End(xlDown)).Row If WorksheetFunction.CountA(Cells) 0 Then lrC = Cells.Find(What:="*", After:=[F5], _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious).Row End If MsgBox lrC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenate with carriage return- how to remove blanks? | Excel Worksheet Functions | |||
Return unique number, skip blanks | Excel Worksheet Functions | |||
Return Unique Records ... No Blanks | Excel Discussion (Misc queries) | |||
selecting cells which contain formulas but return blanks | Excel Discussion (Misc queries) | |||
Replace all non blanks in a column with column header | Excel Discussion (Misc queries) |