I have designed a macro where it replaces cetain value in one column with
something. My problem is that the code works untill it reaches a space(null
value). How can I loop it so that it will ignore the null values and change
all the column values to the end of file. Thanks.