I want to perform a simple task, within a macro.
I created a macro, that searches columns, for specific information. When that information is found, I want the entire row deleted.
For example. My macro prompts the user to enter the data to search for. It then finds the data and then asks if they want that row deleted. How can I make the macro select the current row, that it found the data in.
Thanks...in advance.
Patch
I created a macro, that searches columns, for specific information. When that information is found, I want the entire row deleted.
For example. My macro prompts the user to enter the data to search for. It then finds the data and then asks if they want that row deleted. How can I make the macro select the current row, that it found the data in.
Thanks...in advance.
Patch