Weezer
09-20-2010, 10:06 AM
Hello everyone!
I am trying to write a macro that will show all values in a specific column as blank if it has numbers in it. I'm assuming that I should use a IF-THEN statement for numbers that are greater than or equal to 0. Should I go this way or is there a way I can delete the column entirely after a certain row which is B9. So whatever comes after B9 I would like to delete it and shift it to the left. I think this is a better approach but I don't know how to go about it.
Any help?
I am trying to write a macro that will show all values in a specific column as blank if it has numbers in it. I'm assuming that I should use a IF-THEN statement for numbers that are greater than or equal to 0. Should I go this way or is there a way I can delete the column entirely after a certain row which is B9. So whatever comes after B9 I would like to delete it and shift it to the left. I think this is a better approach but I don't know how to go about it.
Any help?