Sure Juan,
I have a sheet that each row has formulas and formats that are constant. the only exception of course is referencing. I want to copy all the formating to VBA code, so I can make and add-in that will automatically format a header in the first row, and then format the second row with the above formulas and formats. Then I was thinking that after the initialization above, if a user clicks on a row that is not formated, excel would automatically format that row..like the first row...minus any data the user puts in. Is that possible?
thanks John