Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '1004' on server extraction
Hi all,
Im attempting to extract transaction details from an OLAP data source by selecting a cell in a pivot table and issuing the following instruction: ActiveCell.ServerActions("GL Details").Execute Im getting a Run-time error 1004 with explanation The cell that you are trying to change is protected and therefore read-only The underlying visible sheet is the one created by the .Severactions statement for displaying the retrieved data. Cell A1 contains a long string which commences Retrieving data for GL Details ( On clicking the debug button, the data then appears. The macro code appears with the instruction immediately following the .Serveractions highlighted: Range("M4").Formula = " = f4 & ""-"" & worksheetfunction.left(g4,3) & ""-"" & h4" Is there anything wrong with this instruction (Excel 2007)? Can anyone please point me in the right direction? Thanks Bugzee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
run-time error 1004 & comment extraction | Excel Programming |