Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel 2007 Offset bug? (Read 3798 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Excel 2007 Offset bug?
30.03.07 at 11:55:02
Excel 2007 Offset bug?
I think there is a bug in Excel 2007. It seems the Offset function of the Range class cannot be used when the row number is greater than max integer 65535. It did not fail in the immediate pane but it does fail when running the project.
Dim rng as Range
Dim rngFail as Range

Set rng = ActiveSheet.Cells(65600,1)
Set rngFail = rng.Offset(1,0)

The error occurs on the assignment of rngFail.
Back to top
« Last Edit: 30.03.07 at 12:04:55 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1