Hi, I’m a noob. No IT or coding knowledge. Just learn from macro recording and the net with a lot of trial and error. I hope this answer the questions why I cannot understand simple code while I can do the complex one, if any.
What my script do is:

Start
Prepare value from workbooks “WMaster” sheet “SMaster”
Text to Array from List (.txt)
Clear Sheet “RawData”
Loop For (From Arraylist)
Open new book
Insert raw data from .txt (html code), convert and repair data to excel
Copy data to workbooks “WMaster” Sheet “RawData”
Save result RawData
[RawData contain 3000 – 7000 row, and 36-40 columns of number, date, and some text depends on data source. And there is a possibility data increasing to 60 columns.]
Then Aplication.CalculationFull
[Calculate 14 sheet, 12 with UDF function, all sheet has precedents from RawData]
Create Report A1 to A4, take some value from report A paste in other Sheet for preparation creating report B
Save Report A1 to A4
Some Calculation
Clear Sheet “RawData”
End Loop
CreateReport B1-3
End

At the first line of code/script: 
Please Login or Register  to view this content.
And reverse it at the end

My question or problem is in part Clear Sheet “RawData”
This is what I trying to do:
Please Login or Register  to view this content.
I did try ForceFullCalculation set TRUE , the time to delete the sheet takes 00:00:00.025 - 00:00:00.055, but…. there is another piece of code that takes significantly longer
from 00:00:04.513 to 00:00:50.072, sometimes even more.
The part that take longer if ForceFullCalculation set TRUE is this:
Please Login or Register  to view this content.
So is there a way to make the time consume to Clear Sheet “RawData” under 100 millisecond but the other part of the code run fast enough??

Thank you in advance