Based on a value entered in cell, I have conditional formating that highlights the desired row (From column A through column J, say row A50:J50) to red and also turn the font color to grey in all other rows. The row was selected from the patient weights in column A that corresponds to the weight entered in cell F2. I would like to do two things: 1) I would like to automatically scroll to the row that is conditionally formatted to red. 2) Select the row that is conditionally formatted red as my print area and print just that row with the column headings, and then remove the selected print area. I'm brand new to visual basic and I'm trying to learn some visual basic on my own. I would appreciate any help that you can provide. Thanks!