Hi All,

This should be easy but I have no real ideas about VA. In xl I get a spreadsheet that has values from e2:ag452. Where e2 and ag452 can change. What I would like to have is a macro that just

a) adds a row with the number of numbers in each columb i.e.

e454 =COUNT(E2:E452)
f454 =COUNT(F2:F452)
....
ag454 =COUNT(AG2:AG452)
etc

b) adds a columb where I get the min value per row in a new column i.e.

ai2 =MIN(a2:ag2)
ai3 =MIN(a3:ag3)
....
ai452 =MIN(a452:ag452)
etc

Thanks very much,

Mick