I need to use the find function in a macro to find the given value but it has to look above the current cell, not below.
For example, if I'm in cell A100 and I need it to find the next "1", it needs to look in cell A99, then A98, A97 until it finds the first "1". I can't figure out how to make it do this. It always wants to search down from A100 to A101, A102, etc.
I assume this is easy but I've been searching for 30 minutes and can't find anything online on it.
For example, if I'm in cell A100 and I need it to find the next "1", it needs to look in cell A99, then A98, A97 until it finds the first "1". I can't figure out how to make it do this. It always wants to search down from A100 to A101, A102, etc.
I assume this is easy but I've been searching for 30 minutes and can't find anything online on it.
