Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA error in Excel 2003
The following code has been used successfully in Excel 2000 for several
years. My company is beginning to transition users to Excel 2003 and users are calling me to fix errors on several parts of my code. Here is one example: With Sheets(datasheet).Range("A1").CurrentRegion .Offset(, (ReportDataToUseColumnArray(x, ReportDataColumnInDb)) - 1).Resize(, 1).Copy _ Sheets("Report").Range(startCell).Offset(, x - omitIndex) End With The message is visual basic error #400 To solve the problem, I added some error code "Resume Next" and the macro runs just fine. Everything that is supposed to be copied, copies just fine, but without the "Resume Next" the code errors out. any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Error in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 serious error | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
MID$ error in excel 2003 | Excel Programming |