I am trying to record a macro that will do an insert and add a COUNTIF formula to every row that has data in it...problem is when I record it only adds the numbe of rows specified. Is there a way to tell it to add it every row that has data or would I have to add it to all of the rows? When I am recording I hit shift and double click the bottom right corner to carry it down but it only records the actual number of cells it copies it to.