Results 1 to 2 of 2
  1. #1
    allenjasonbrown@gmail.com is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    44

    Delete Contents of worksheet before export - xlWSh.Cells.Select

    I am just trying to delete the contents of a worksheet before adding new data.



    I found that I can use this to select the entire worksheet:

    xlWSh.Cells.Select

    But I cannot find command to delete data??

    THanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,628
    Review http://www.ozgrid.com/forum/showthread.php?t=23087

    I don't think you even need the .Select line.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. export query to hidden excel worksheet
    By allenjasonbrown@gmail.com in forum Programming
    Replies: 3
    Last Post: 10-14-2012, 12:39 PM
  2. code to delete rows based of empty cells
    By jcbrackett in forum Programming
    Replies: 3
    Last Post: 03-05-2012, 02:27 PM
  3. Vba Code delete&shift up cells- Access 2007
    By Luca87itc in forum Programming
    Replies: 2
    Last Post: 02-08-2012, 02:36 AM
  4. Replies: 6
    Last Post: 11-05-2011, 09:01 AM
  5. Delete cells <= 2 letter values
    By melting in forum Access
    Replies: 5
    Last Post: 05-14-2011, 07:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums