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

Re: $$Excel-Macros$$

2013-11-16 Thread xlstime
creditor details sheet missing . Enjoy Team XLS On Sat, Nov 16, 2013 at 6:39 PM, Sharad Shroff shroff.sha...@gmail.comwrote: The attach file has a worksheet named Sub-Ledger which contains List of Sundry Creditors with their address and other detail i want the

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data

2013-11-16 Thread xlstime
attachment missing . Enjoy Team XLS On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma rajansharma9...@gmail.comwrote: Dear experts, I am unable to write the formula for the attached excel file. Please help me to create formula please..i have tried many a