Most valuable professional
  • Hot Topics

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 0 789 0

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

This thread is current as of July 1, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel