4n to add userfom range wk
1-add button in CE2 to CH2 call it " RANGELOOKUP"
2-than add userfom ( same as in ORDFROM Button )
3-columns CG have the key for the subform
Try this. I don't know if you noticed but in previous versions selecting AZ as one of the columns gave #REF! errors in the results for that column.
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent