Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB scripped works in Excel 2003 but fails in 2007
Our roll out of Office 2007 has been put on hold because our engineering
department has an excel spreadsheet in Excel 2003 they have used for years but fails in Excel 2007 The error is Run-time error '-2147417848 (800 10 108)': Method 'Offset' of object 'Range' failed When I run debug after the failure this is the section of code that is high lighted .Chart.SetSourceData _ Source:=.TopLeftCell.Offset(0, -3).Resize(RepMeasurements, 2), _ PlotBy:=xlColumns I'm a network guy so VB is not my strong point. Thank you for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF formula works in Excel 2003, does not work in Excel 2007 | Excel Discussion (Misc queries) | |||
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 | Excel Worksheet Functions | |||
xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
chart works in excel 2007, not 2003 | Excel Programming |