I know that it doesn't make sense but Excel will NOT accept all sheets in a
macro for this. Use the suggested loop. Fast
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"REMB" wrote in message
...
I want to select all sheets in a workbook, insert a column, and put a
formula
in that column. It works fine when doing it manually, but if I try to have
a
macro do this, it only affects one sheet. Is there any way to do this?