Thread: macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Natalie Natalie is offline
external usenet poster
 
Posts: 44
Default macro

I would like to record a macro that allows me to insert a new sheet. However,
it inserts a DIFFERENT sheet no everytime. How should I write a sub that will
technically allow me to insert a new sheet rather than a predefined sheet
name like sheet 4 or sheet 5? thanks