• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    send pdf file not working in office 2016

    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...
  2. A

    send pdf file not working in office 2016

    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
  3. A

    send pdf file not working in office 2016

    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...
  4. A

    Dear Sir, Can you help me please... vba code not working after upgrading office to 2016...

    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/
  5. A

    send pdf file not working in office 2016

    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...
  6. A

    copy cell value in a range and paste specific numberof rows below

    Dear Pcosta, Great.. thank you.
  7. A

    copy cell value in a range and paste specific numberof rows below

    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
  8. A

    copy cell value in a range and paste specific numberof rows below

    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...
  9. A

    Copy data and paste in concerned sheet in list

    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
  10. A

    Copy data and paste in concerned sheet in list

    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
  11. A

    Copy data and paste in concerned sheet in list

    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
  12. A

    Copy data and paste in concerned sheet in list

    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
  13. A

    Copy data and paste in concerned sheet in list

    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...
  14. A

    Copy the 20 line item and paste in a format to print

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

    Copy the 20 line item and paste in a format to print

    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...
  16. A

    Dear Sir, Appreciate your help on below...

    Dear Sir, Appreciate your help on below. http://forum.chandoo.org/threads/copy-the-20-line-item-and-paste-in-a-format-to-print.32884/
  17. A

    Dear Sir, You have helped many time, can u please help on below too...

    Dear Sir, You have helped many time, can u please help on below too http://forum.chandoo.org/threads/copy-the-20-line-item-and-paste-in-a-format-to-print.32884/
  18. A

    Copy the 20 line item and paste in a format to print

    Dear experts, Any help please... Thanks Abdul
  19. A

    Copy the 20 line item and paste in a format to print

    Dear Monty, Thank you for your help.. it just copy 20 line one time, please find the below requirement already detailed in the last email. - If field Entry Number of Sheet Data in total 19 rows or below, it should copy that rows and Print. total count should come in G34 and sum in I34. Page...
  20. A

    Copy the 20 line item and paste in a format to print

    Thank you for your reply PCosta. Please find the attachment, I have data listed in the Sheet named Data. I wanted to bring the data in Sheet <Format> and print by field Entry Number. In the Sheet Format can accommodate 19 rows, therefore If field Entry Number of Sheet Data in 19 rows or below...
  21. A

    Copy the 20 line item and paste in a format to print

    Dear Experts, I am stuck with something, would be really helpful if a solution. I have data in A2:L5000 in sheet1. in column 'I' it is 'Amount' and in Column 'D' it is 'Entry number' In sheet2 I have format set with letter head which can accommodate 19 row. I wanted to copy each 19 rows from...
  22. A

    to bring abbreviation B for billion and T for trillion.

    Hi friends, I have number trillion and million in a column and make it to the chart. the follow code pasted in the format cell custom- working fine for million and billion. Please help me how do i get it work for trillion too. [&#62;999999999.999]#.0,,, _-"B";[&#62;999999.999]#.0,, "M";#,##0...
  23. A

    Million and Trillion short form in cell

    Hi Luke, thanks for the link. sorry i am unabe to find the solution in the link provided. any one have any...even in the VBA Regards Abdul
  24. A

    Million and Trillion short form in cell

    HI, I have below custom to display B instead of billion an M and instead of million. could you tell me how to add trillion also to this [&#62;999999999.999]#.0,,, _-"B";[&#62;999999.999]#.0,, "M";#,##0 _M Regards Abdul
  25. A

    Extract from one sheet to different sheets

    Dear Hui, Thanks for this. Second link is half suitable for me. this is extracting to different workbook. i wanted to extract in different sheets in the same workbook which already available with name of filtering value. Please advice Thanks Abdul
Top