k13r4n
02-15-2009, 01:59 PM
Hi all
Ive writen a pretty heavy macro that uses .Find(Value) and .FindNext(Value) to find some info in a spreadsheet and pull all ascosiated data. That all works perfectly and does exactly what i wanted but now they want it to be able to find cells that contain a Value between 2 numbers :banghead:
Ive come up with a way to do it using 'if then else' and 'select cases' etc but it requires a complete re-write of a large chunk of code.
Is it possible to use .Find(value) to do this?? if it is it's gona save me a load of hassle.
E.G.
i have a variable T and i want to find cells that have a value in the range of plus or minus 1.5 from T, IE if T = 5 i want to find everything from 3.5 to 6.5 inclusive.
Chears for any help
Kieran
Ive writen a pretty heavy macro that uses .Find(Value) and .FindNext(Value) to find some info in a spreadsheet and pull all ascosiated data. That all works perfectly and does exactly what i wanted but now they want it to be able to find cells that contain a Value between 2 numbers :banghead:
Ive come up with a way to do it using 'if then else' and 'select cases' etc but it requires a complete re-write of a large chunk of code.
Is it possible to use .Find(value) to do this?? if it is it's gona save me a load of hassle.
E.G.
i have a variable T and i want to find cells that have a value in the range of plus or minus 1.5 from T, IE if T = 5 i want to find everything from 3.5 to 6.5 inclusive.
Chears for any help
Kieran