Rapid Implementation General Ledger Excel Spreadsheet Step 1 Validate, Run-time Error 9 Subscript Out Of Range (Doc ID 2342055.1)

Last updated on MAY 12, 2020

Applies to:

Symptoms

When running the Step 1: Validate on the Rapid Implementation General Ledger Excel Spreadsheet the following error occurs:

Microsoft Visual Basic
Run-time error '9':
Subscript out of range

Steps to reproduce the issue:

1. Open a previously used RapidImplementation General Ledger Spreadsheet.

2. Change the Chart of Accounts segment names in the 'COA, Calendar, and Ledger' sheet.

3. Save the work.

4. In the 'COA, Calendar, and Ledger' sheet press the 'Step 1: Validate' button

-> Error:

Microsoft Visual Basic
Run-time error '9':
Subscript out of range 

Debug shows the following line as the one causing the error:

Sub checkValidValues(worksheetname As String, valReportSheet As String, iErrorCounter As Integer)

Dim rCell As Range
Dim rRng As Range
Dim lastRow As Long

lastRow = Sheets(worksheetname).Range("L" & "1048576").End(xlUp).row

Due to this error validation cannot continue and structure cannot be uploaded to Fusion Applications

Changes

The spreadsheet file was used from another project and some information was replaced with new values for a new project, also using cut and paste and drag and drop (using pasting only values function in Excel)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.