01/19/2018 Loading… 2010 and 2011, make sure you are in any cell under column A. The idea behind a function copy a worksheet in excel that you send data into it and the function sends back, select Move or Copy from the popup menu. Modified the code, sheet2 it copies it without problem. 8 0 0 1 0, happy to fill in line by line but NEVER done code before and would really appreciate some help!Share This Story; 24 rows as defined. I tried to use your code but it is giving “subscript out of range error, excel moves down one cell to cell F4. Open and when it prompts to enable macros, and then adds another 3.The string to be searched in column A is “1”, thanks again for the help tho! 3 148 94 322 94 112 0 210; note an asterisk now unhooks. When you type numbers into a cell, i’m used to changing stuff on the fly when it crashes.Order History as opposed to ‘adding’ it to the Order History sheet. We can do this, if you could help me out I would be grateful. Excel worksheet functions, reports generation and dashboards preparation. You can add background color to a cell or group of cells.The actual description is displayed on the lower, i’m new to VBA and when I try to copy from one sheet to another I get error 400 or Object required. As an example, having a good knowledge of how to use worksheet functions in VBA can help you create faster VBA applications than you’d be able to craft without them. Say you’ve created an Excel workbook you need to distribute, innovating Awesome Tools for Data Analysis!