Re: $$Excel-Macros$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

2013-11-16 Thread Eugene Bernard
Please verify the data on 266th row, with the data above 266 rows. Regards Eugene On Thu, Nov 7, 2013 at 1:59 AM, Denisetoo denise...@gmail.com wrote: I get a run time 1004 when the comment lines are at 266 lines. WIth less than 200 comment lines the code runs fine. The DropDownTmp

Re: $$Excel-Macros$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

2013-11-16 Thread Denise James
Thank you for your response Eugene. I have a fix that stops adding comments after 250 and mention in the comment section to list the 250 and mention there are too many to list. I appreciate your help. I will look at your suggestion and let you know. On Sat, Nov 16, 2013 at 8:02 AM, Eugene

$$Excel-Macros$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

2013-11-06 Thread Denisetoo
I get a run time 1004 when the comment lines are at 266 lines. WIth less than 200 comment lines the code runs fine. The DropDownTmp variable list includes all 266 lines. The comment field cuts off around 253 lines of code. The program stops with the run time error. Any ideas on how to fix