GMan
02-03-2007, 04:39 PM
I am copying a cell from one workbook to another. However, when the cells text gets to large (greater than 250 characters it seems, I currently have a cell with 999 that I am working with this issue.) the line creates and error. Is there a better way to complete this tasks or some way to get around the limit?
The line of code that I am using is:
Workbooks(1).Worksheets(1).Cells(1,5) = Workbooks(2).Worksheets(1).Cells(1,5)
Not sure if this will help at all... But the error information that I am receiving is below:
Err.Number = 1004
Err.Source = VBAProject
Err.Description = Application-defined or object-defined error
Thanks,
Gregor
The line of code that I am using is:
Workbooks(1).Worksheets(1).Cells(1,5) = Workbooks(2).Worksheets(1).Cells(1,5)
Not sure if this will help at all... But the error information that I am receiving is below:
Err.Number = 1004
Err.Source = VBAProject
Err.Description = Application-defined or object-defined error
Thanks,
Gregor