What are you currently using to terminate the loop? Do you have an 'For',
'Until', 'While' or 'If ... Exit' clause? If you provide the existing loop
construct, we'll be better able to help.

"Purnima Sharma" wrote:

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.