View Single Post
  #2   Report Post  
njmikec njmikec is offline
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by REMB View Post
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?