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
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