Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lastrow
I'm familiar with this code to find the last row:
LastRow = .Range("A" & Rows.Count).End(xlUp).Row But what if I need LastRow to be at a certain value? If I know column A is going to have data and I want to assign LastRow the first row that has a value of 0 how would I do that? What if I need LastRow to be the row 2 rows above the first row that has a value of 0? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lastrow | Excel Worksheet Functions | |||
HELP Lastrow Range | Excel Discussion (Misc queries) | |||
LastRow of Data | Excel Worksheet Functions | |||
Type mismatch on LastRow | Excel Discussion (Misc queries) | |||
Lastrow in Range | Excel Discussion (Misc queries) |