I would start by recording a macro of you selecting a cell, then select an entire row, then select an entire column. Then end the macro recording. That way you have the syntax of how you need to program the code. Then go to edit macros and change the select row code and the select column code. You can use variables to capture the column and row of the selected cell, then use those same variables to designate the select row and select column lines of code. Easy.you barely even have to write any code. The record macro does most of the work for you.