To be quiet honest I dont know why it didnt assign the cell value to
the variable but I had the variable assgined before the macro populated
the cells which the count formula counted. Now I assigned the
variable after count has something to count after the macro populates
the cells and it works fine...

Why that is, I have no clue..

Matt