Excel: Auto select?

Hello All! Is it possible to create a rule or VBA that says, if the data is column A is not 0 then select that entire row, or all the data in that row? So, in the below scenario when I paste the following data in the spreadsheet, it would automatically select the row, or all the data in the rows with 123 and 789? Or is there an easier what to do that without manually selecting the rows? I'm not sure if I am asking this correctly.

123 0 AAA
0 0 BBB
0 0 CCC
789 0 DDD
0 0 EEE

This question generated 7 answers. To proceed to the answers, click here.

This thread is current as of July 01, 2017.

For more resources for Microsoft Excel