The following formula used to work, until I added a custom hyperlink to the sheet. The hyperlink works, but I get the error message. I am assuming there's something wrong with my range references in the Union formula.

This formula ensures there are two empty rows in the comment range _1BidRemarks on the bid form, so the area on the bid form for remarks will expand to only as big as needed (by unhiding otherwise hidden rows). It's been working fine.

Please Login or Register  to view this content.