Okay. this is what I coul find out. There is a method called ExecuteExcel4Macro with a string parameter and this has something to do with the groupings and the showing of details. the only problem is I can seem to get it to work outside of a recorded macro?? very strange. Perhaps someone more knowledgeable in Excel will be able to figure it out, personally I'm stumped.


'This works on R1C1 calls??
ExecuteExcel4Macro "SHOW.DETAIL(2,3,TRUE,,0)"