PDA

View Full Version : find last used row but not include formula that returns blank



omp001
11-27-2011, 04:12 AM
Hi all.
Eg. C15 has a formula that returns blank and A12 holds "Sunday".
Using 'UsedRange.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row' I get row 15.
Is there a way to not consider cells with formula that returns blank and, in this case, get 12 instead?
Thanks in advance

p45cal
11-27-2011, 06:57 AM
UsedRange.Find(What:="*", lookat:=xlWhole, LookIn:=xlValues, SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row?

omp001
11-27-2011, 07:15 AM
Howdy, p45cal.
Beautiful. Thanx so much. Nice Sunday.

Capungo
11-28-2011, 01:33 PM
:))