Quote:
Originally Posted by REMB
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?
|
Have you tried recording the Macro on Sheet 1 first, then holding down shift, and hilighting all tabs and running the Macro?