Hi experts
I have set of data which is stored in path location as excel file AMP_aus.xlsx ,i want delete the one particular sheet and clear range of another 6 sheet
RAWDATA should be deleted.
Remove Range A2:BG Leave First header row A1:BG1.
These 6 sheet range should be clear
ACOMMS
AUSTRAC
AML
ACT_AUS
AUS_NZ_SQUAD
CTF
file stored at C:\Users\Windows 10\Desktop\AMP_aus.xlsx
find the attachment
AMP_aus.xlsx is a non macro workbook so you need to run the macro from another workbook.
You also give us the path and folder where this workbook is stored so I assume we need to open the workbook, run the macro on it and save it again.
The attachment has 7 sheets, one will be deleted so there will be 6 sheets only to clear. Is there a chance that there will be other sheets in this workbook?
Not tested so try on a copy of your workbook.
Please Login or Register to view this content.
The inherent weakness of the liberal society: a too rosy view of humanity.
If you have more sheets in that workbook.
Please Login or Register to view this content.
Thanks alot Boss Solved!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks