Edit macro code?

[fairymemay (noona)]

I have a question about code VBA.
I edit code in VBACode from 21 to 34 (according row in excel —> some month have 31 days)

If I run , It write text Data in row34 column B as below.

VBACode.txt (24.4 KB)
input : output2.xls (61 KB)
output : 04-2021.xlsx (27.1 KB)

I think text data from table pivot as below.

How to delete text Data in file output.

Please guide me about it.