I was not able to Write on the excel When Pivot Table is Created

I was not able to Write on the excel When Pivot Table is Created Can you please help me with any Solution for that ??

Error:" index was out of range. must be non-negative and less than the size of the collection"

FYI- When i was write without “Pivot” Sheet (Sheet Which have Pivot Table) no error.
@NIVED_NAMBIAR

Hi @Jayavignesh_G ,

Try to do it from invoke code.
Is it possible for you to share that excel?

Sorry… No. Can you please the VBA Code ??

So you are writing on one cell or writing as a whole data table