View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Hargreaves[_2_] Rob Hargreaves[_2_] is offline
external usenet poster
 
Posts: 32
Default supressing a message in vba

Hi



I have a button to export and cut rows to another spreadsheet. Excel promts
me on moving the rows that I have named ranges on the sourcesheet with the
same names as on the destination sheet. Would I like to keep the names the
same or change them?



I always want to keep the named ranges the same so that the rows when added
will work the same as they will contain the same data in the named ranges.



Can someone tell me how to stop the messages?



Thanks

Rob