Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    How to save a range only (2000)

    I have a worksheet that with a fancy layout including column headers and comments. The purpose is to assist the user with filling in values in each column begining with row #5. One the info has been entered the user needs to save that info only to a new csv file. I have achieved this by inserting a new worksheet and copying the range to that new worksheet, saving that worksheet as a csv file and then deleting the worksheet. The only problem is that the user is prompted about deleting the worksheet. I would like for this process to be invisible to the user with no interaction other that starting the process. Any suggestions?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: How to save a range only (2000)

    Have you tried application.displayalerts = false (don't forget to set it back to true at the end of your procedure.)
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •