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

Jayavignesh_G · July 9, 2021, 7:50am

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

ermanoj3101 · July 9, 2021, 7:54am

Hi @Jayavignesh_G ,

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

Jayavignesh_G · July 9, 2021, 8:30am

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

ermanoj3101 · July 9, 2021, 10:19am

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

Cristian_Negulescu · November 25, 2021, 7:15pm

Hello,
Here I have a Video with code of how I create Pivot Tabel:

Code VBA you can other stuff inside of VBA:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/VBAFile.vbs

Sub MyVBA()

Set PSheet = Worksheets("Rez2")
Set DSheet = Worksheets("Test")

'Define Data Range
LastRow = DSheet.Cells(Rows.Count, 1).End(xlUp).Row
LastCol = DSheet.Cells(1, Columns.Count).End(xlToLeft).Column
Set PRange = DSheet.Cells(1, 1).Resize(LastRow, LastCol)


'Define Pivot Cache
Set PCache = ActiveWorkbook.PivotCaches.Create _
(SourceType:=xlDatabase, SourceData:=PRange)


'Insert Blank Pivot Table
Set PTable = PCache.CreatePivotTable _
(TableDestination:=PSheet.Cells(1, 1), TableName:="RezPivot")
PTable.ClearTable

This file has been truncated. show original

Thanks,
Cristian

Topic		Replies	Views
Write Range: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Studio studio , question , activities_panel	13	1899	September 16, 2022
Index was out of range. Append to XL Studio studio , question , project_panel	4	1058	March 23, 2022
Creation of Pivot Table Help excel , activities , question	9	2307	March 3, 2020
Write Range error of Workbook Help	23	4320	August 29, 2022
Read Range: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index Studio	10	5327	May 25, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

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

Related Topics