Thanks. It worked!

Mallycat wrote:
I'm not sure if you are trying to do this manual or in VBA. Th
principle is
1) select all the blanks
2) use the autosum

To select the blanks, first select the entire column, then us
goto\special\blanks. This will select them all at once. Then jus
click the AutoSum tool and you're done. You should ( I assume) be abl
to do both of these things using Application.WorksheetFunction in VBA

Mat

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1