Excel - Retrieve more than 1024 char in a Cell ?
I am using Microsoft Excel Version 2002.
I have a cell which contains around 2000 charcters. I want to copy all the characters from one cell and paste in another cell using Macro (VB).
According to Excel specification, we can copy maximum 1024 from a particular cell.
Is there any workaround to copy more than 1024 characters using Macro(VB)?
Re: Excel - Retrieve more than 1024 char in a Cell ?
You can copy the cell value to a variable and copy the variable content to particular cell. It should work.
BTW, this is not the right forum for this question.