View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dale Fye Dale Fye is offline
external usenet poster
 
Posts: 169
Default Move worksheet within workbook

I am writing a custom Access routine to populate a specific worksheet in an
Excel Workbook (the access transferspreadsheet and outputto will not let you
specify a specific worksheet). i've got this working. However, if the
worksheet I want to write to does not exist, I have to add it (no problem
here either).

However, I would like to add it as the last worksheet in the workbook, and
have not figured out how to do this. When I select the last worksheet, and
then add the new one, it inserts it before the last sheet rather than placing
it behind it. How can I, programmatically, change the order so the new sheet
becomes the last one in the workbook?