Recent content by abdulncr

Thank you Kenneth for your help. sorry, I missed the pw, I attached file after removing the pw. PDF file saved in the same folder in path, same can be seen on search after copy paste path address in the search. when I run the macro line by line with F8, .Display not bringing opening outlook, I...

Dear Kenneth, Thank you for your time. I checked the PDF file in the path, it is existing. As required, please find the sample file attached here with. Request your help on the same. Thanks Abaad

Dear Narayanan, Sorry, I was sick and off for two days. Thank you for your response No error message is popping, just end the procedure within 4 second without any action. already commented on On error..., still no error message. I tried to debug the code, each time variable value I checked...

Dear Sir, Can you help me please... vba code not working after upgrading office to 2016 https://chandoo.org/forum/threads/send-pdf-file-not-working-in-office-2016.36476/

Dear Friends, I have below code to send PDF files from the path address given, it was working perfectly. after upgrading to office 2016, it is not working at all. any help please... Sub Send_Row_Or_Rows_pdf_Attachment_1() If MsgBox(" Please make sure, you want to send the email to all the...

Dear Pcosta, Great.. thank you.

Dear PCosta, Thanks for your reply. it is pasting value of row 9 in entire row. I wanted to paste value of 9 in below 16 times, then there is value in 62, that also to be copied and pasted just below 16 times.. and so on. Hope I conveyed correctly. Thanks Abd

Dear Friends, I am trying to write a code to copy cell value in a range if not equal to blank and paste below16 rows from active cell,after pasting one value it should go to next value in the range and do the same. below code is doing the first task and not going next value. sample file is...

Dear Jindon, Really great, working elegant. I know little code, but it is bouncing to my head, create object is new to me. is it possible to help to learn this If Evaluate("isref('" & e & "'!a1)") Then dic(e).Copy Sheets Thanks abd

Friends, I have attached sample file with code, where the sheet name is mentioned in C, I wanted copy value1, value2, and value3 and paste in concerned sheet in 25th row. I tried with lot of change. not succeeded this case. Appreciate your help

Dear Jindon, thanks for your reply. in your solution if there are five lines to copy to concerned sheet, it copy all five line in 25th row replacing the first value, so only last value remain cell

Dear Derek, Thank you for your reply. in your solution if there are five lines to copy to concerned sheet, it make the gap of 25 rows between each line. Thanks Abd

Dear Friends, I have below code to copy the data and paste in concerned sheet, sheet name is mentioned Sheet98.Range("C12:C137"). this is perfectly working, currently it is pasting in the second row of concerned sheet, I wanted paste data 25th row of concerned sheet, I am trying to change the...

Dear Sir, Work like a charm...!!! thank you so much. Regards Abdul

Dear Sir, Amazing...Thank you so much for your help. much appreciated. Yes, Data should break by column D. currently it is copying 19 rows one by one and printing without break.. below change is required in the code -it is to break by Column 'D'. Total in "I34" and count in "G34" at each...