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.
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.
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.