EGL9.2: JRNLS1.XLSM Issues A "Run-Time Error ‘1004’ Method ‘Range’ Of Object ‘_Global” Failed" When Deleting The Last Column In The Spreadsheet
(Doc ID 1605346.1)
Last updated on APRIL 17, 2025
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Errors
====
Multiple upon modification of the spreadsheet import file JRNLS1.xlsm
. Run-time error: 1004 Method Range’ of object ‘ _Global’ failed
Stops at
Case Range(“LastLineCol”).Column from JRNL1.xls(break) [Form_CustomizeCF(code)]
Can not save changes so tries inserting 14001 rows and
. Run-time error: 1004 Method Range’ of object ‘ _Global’ failed
the vb stops at
JRNL1.xls(break)-[mJournalEntry(Code)]
NewLine.Range(Cells(1, 8), Cells(1, Range(“LastLineCol”.Column -1), Locked =False
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |