View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RichardO[_14_] RichardO[_14_] is offline
external usenet poster
 
Posts: 1
Default count value in column and VBA

Hi all:

I hope you can help with the following:

How do I write a macro that would count the number of cells in column
(column 19) that has a "NO"
then I want excel to go to the last row and insert "Total count" i
column R and the # of cells with a "NO" in column S,
Is it possible to do this with a macro?

thanks for helping

Richard

--
Message posted from http://www.ExcelForum.com