View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IanRC IanRC is offline
external usenet poster
 
Posts: 3
Default Why does copy after worksheets command not work on some computers

I have written a VBA macro for an Excel 2003 workbook. Amongst other things,
at the end of the month it is intended to copy the most recent monthly sheet
and add it as a fresh copy as the new month's sheet for editing.

The weird thing is that, although this works fine on my laptop and most
other computers I have tried it on, it will not work on my desktop computer,
even if I copy exactly the same file across from one to the other.

Grateful for any pointers

Thx

Ian