Macro if detect any value put assigned value in all range

[feroguz]

Hi master's! :D

I need help, because I don't know how to do, create a function that I assign a value (0.001) when it detects a cell "A".
I try, but itīs limit that range B2:B10, etc.. I need to detect automatically the range and put assign value 0.001.

Thanks a lot!
Best, regards.

Capture.JPG