2009年9月8日 · Perhaps you could copy and paste the code i posted and try how it works on your pc in excel 2007. Then you should get all the information you need to help me. Please correct me if I am wrong but I think this is the best way to see where the problem is. Thanks in advance.

2015年4月21日 · If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

2012年3月11日 · but I'm getting Runtime error '1004' Unable to get the Xirr property of the worksheet function class on the line marked in red. What am I doing wrong? According to the help file Xirr is one of the functions that are available to VBA. P.S. It's MS Office 2010.

2015年2月28日 · I.m building an application where I transfer a series of data to an excel workshhet, in 5 columns (12,000+ rows) I need to sort the whole range, but I get a "Run-time error '1004'.

2017年8月2日 · I'm getting a runtime error 1004 - unable to get the pivot table property of the workclass sheet. The error comes up at line With ActiveSheet.PivotTables ("PTable").PivotFields ("Work Centre")

2006年8月9日 · The only thing is, the data will still be "attached" to the original file. I just want the values/formatting copied over. Just as a simple example, one of the cells in the sheet I want to copy over is something like: IF (Customer!I5<>"",Customer!I5,"") But if I just straight copy the whole sheet into the new book, it would become: IF ( [name.xls]Customer!I5<>"", …

2017年10月13日 · ' Put the cursor in the top left of the data - the ActiveCell Range(ActiveCell, ActiveCell.resize(4, 4)).Copy

2011年8月24日 · Thanks Westconn, I tried your suggestions, but was still getting the same error; Runtime Error 1004: unable to get the find property of the worksheetfunction class In ...

2012年4月18日 · I get this error message: Run-time error '1004': Application-defined or object-defined error This is the statement that is highlighted when the error comes up. ActiveCell.FormulaR1C1 = "=Average (RC:RC)"

2016年10月18日 · Run-time error '1004': Unable to set the LeftHeader property of the PageSetup class