Nearest smallest and biggest number VBA issue

[gan_xl]

Hi,

Please have a look at the attached file.
Using the below code I am just finding nearest biggest number and nearest smallest number

Please Login or Register  to view this content.

first statement 'small_x' showing error if I enter 'price_value' equal to '0' since there is no less value than '0' in the attached file
last statement 'large_x' showing error if I enter 'price_value' equal to '400' since there is no higher value than '400' in the attached file

Kindly help me to correct the above code to return '0' and '400' instead of showing error.

Thanks

[adyteo]

Would this work?

Please Login or Register  to view this content.

[gan_xl]

Hi adyteo,

both showing compilation error

Please Login or Register  to view this content.

[adyteo]

Please Login or Register  to view this content.

[adyteo]

Please Login or Register  to view this content.