Hi,
I have a named range of cells D19:D1000 (EntryAreaProposal). There is data above this range and below this range. I want to find the last used row within this range and of course if I use something like:

LastRow = wks2.Cells(Rows.Count, "D").End(xlUp).Row

it hits the data below my range and give me "that" last row instead of what I need. I know this has to be simple, but it's worn me out trying to find something in the archives.
Help please.