• 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. H

    Copy paste an Excel table into Microsoft Word in a specific page with VBA

    Hi I am actually encountering an issue on VBA. My objective is to copy an excel table into a word document to a specific page number using VBA code. Please check the uploaded file. Thanks for your reply Hansa
  2. H

    Macro where there are merge cell

    Hi I've got a form where there are merged cells, I need to create a macro where it will copy and unmerged the cells and paste the data in a single cell for each and every field. Actually I've been able to record the macro, but unfortunately for some fields it's not working due to the merge...
  3. H

    Indirect formula in excel using R1C1 Reference style

    Can anyone help me to understand the below formula: =INDIRECT(("data!R2C"&43+IF($E$4<7,$E$4+5,$E$4-7)&":R10000C"&43+IF($E$4<7,$E$4+5,$E$4-7)),FALSE) Why do we use the R1C1 reference style in a formula, why don't we use the cell reference directly, that is A1, B4, etc... Thanks
Back
Top