VBA code to select cells, row by row in range, based on condition

Hi Excel experts (sorry it was a typo/copy/paste malfunction; you don't need to be so bitter, there r planty of good excel forums to make me not use this one). I haven’t been in the forum for so long, I am sure that I will get help from experts. I am struggling to solve this easy problem but for some reason I cannot make it work. Here is the question and the scenario.

I have formulas grabbing info from another spreadsheet.
I have formulas in the range of A1:F20
The formulas results, if there are info in the respective row on the other sheet, in column A , I get 1, 2 ,3 etc if the B1:F1, B2:F2..Bn:Fn has info. If the next row doesn't have info, the result in cells would be "".

So for every Cell in my range A1:F20

if A1 is not "", Highlight yellow A1:F1, Print, Remove Highlight

next cell

if A2 is not "", Highlight yellow A2:F2, Print, Remove Highlight

and so on until it reaches the last row with info, not "".

The best that I got was that it highlights and prints the whole range, row by row, even if the respective row/cells don't have resulting info, but it prints them because they have formulas.

Any help greatly appreciated.

Thank you

Vera