Hi
1) There is no checking on the input to the input box. You would have to restrict things. Maybe
2) I just grabbed one of your formulas that you had and pasted it in. Your example seemed to take the same formula regardless of the row position, so I just left it there.
Couple of things you could do
a) Convert to a RC format so you are not specifying the row
b) Use the row from the variable ce (
) and dynamically build the formula that way. Plenty of examples on the site of how this can be done.
rylo
Bookmarks