Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run-time error '1004'
I have a macro (Excel 2003) which goes to a range (Range 1) of four columns
and 100 rows to copy to another range (Range 2). The first column of Range 1 contains bandomly-generated numbers (=RAND()). I have been using this file for quite some time without any problem, as have a number of other people. One user has reported that he is receiving a Run-time error '1004' each time he tries to execute the macro. I have read the MS info re this error which says: "This issue may occur if one or more of the cells in an array (range of cells) contain a character string that is set to contain more than 911 characters." I have had trouble following the MS workaround which seems incredibly complex. I have formated the random number column to ensure no more than 10 digits after the decimal point. Can anyone offer any practical solutions to this issue? -- Regards goconnor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error '1004' | Excel Worksheet Functions | |||
run time error 1004 | Excel Discussion (Misc queries) | |||
Run time error 1004 | Excel Discussion (Misc queries) | |||
Run-time error '1004 | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel |