Looping through columns on the same row, changing cell values to NULL

[Lifeseeker]

Hi,

How should the syntax go? I would like to look through a range first. And if the cells(target.row, 1).value = vbNullString then, I want all subsequent values on the same row in all columns to be "". There is a total of 26 columns.

code segment is: If I have 100 columns, then I would need to write 100 lines....which is not very efficient.

Please Login or Register  to view this content.

Thanks for your input

[Trebor76]

Hi there,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[Lifeseeker]

Hi there,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

Perfect, and it works!

Thanks