Quote:
Originally Posted by macropod
Why use VBA at all, when you use a simple formula on each row:
=VALUE(D5)
with whatever regional cell formatting you require?
|
Thank you for your help. For some reason, value formula doesn't work as it returned as#value! error.