W
wilro85
Alright y'all. I have a [very cumbersome] solution to a particular
problem, but I'd like to know if there is a better one.
The setup: Basically, I have buttons that hide and show different
options further down the sheet which leads to other buttons and such.
The problem: When unhiding rows (and the buttons that corresponds) the
*button*.top = number changes depending on how many rows are shown.
On another sheet I just brute forced it and worked out every option and
put an if-then for every option. If at all possible, I'd like to avoid
doing that again.
Does anyone have any ideas in which direction I could take this?
problem, but I'd like to know if there is a better one.
The setup: Basically, I have buttons that hide and show different
options further down the sheet which leads to other buttons and such.
The problem: When unhiding rows (and the buttons that corresponds) the
*button*.top = number changes depending on how many rows are shown.
On another sheet I just brute forced it and worked out every option and
put an if-then for every option. If at all possible, I'd like to avoid
doing that again.
Does anyone have any ideas in which direction I could take this?