Hi Guys,

I have a macro that is inserting a rows then populating them with data.

In the macro a variable (rw) has been set with the row number of the newly inserted row.

What I would like to do:-

Get the existing macro to insert a formula to count how many cells in row rw from column F to DD are populated.


So, when the macro is played this time it would read:-

.Cells(rw, 4).Value = COUNTIF(F108:DD108,">0").Value

And next time

.Cells(rw, 4).Value = COUNTIF(F109:DD109,">0").Value

So, what I am after is the correct syntax for:-

.Cells(rw, 4).Value = COUNTIF(Frw:DDrw,">0").Value

Any help would be greatly appreciated,

Keith