hi
Just wondering is it possible to clear cells multiple columns based on the criteria instead of column by column.
For example:
What i am trying to do i have a file with 28000 lines and want the macro to clear contents of the cells in columns W,X,Z,&AA that contain #N/A.
Can this be done ? Your wisdom would be great
Just wondering is it possible to clear cells multiple columns based on the criteria instead of column by column.
For example:
What i am trying to do i have a file with 28000 lines and want the macro to clear contents of the cells in columns W,X,Z,&AA that contain #N/A.
Can this be done ? Your wisdom would be great
