What i am trying to do is count the number of rows that contain data.

It will always start in A7 and when creating the macro i hit control-shift-down arrow.

There will be a differnt number of rows for each data set. When i ran the macro it kept the result of the first data set that i used to create the macro.

here is the code:

Columns("B:L").Select
Range("B2").Activate
Columns("B:L").EntireColumn.AutoFit
Range("B4").Select
ActiveCell.FormulaR1C1 = "=COUNT(R[3]C[-1]:R[7199]C[-1])"
Thanks for any help you may be able to provide!