From the Offices field table, drag the Region and District columns to the Rows section in the Pivot Table Fields List. Use the mouse to place the cursor in Cell A1 and type the name Region & District into the cell to change the default heading name....
However, this portion of the function (ADDRESS(COLUMN(B4)-COLUMN($B$4)+ROW($B$4),ROW(B4)-ROW($B$4)+COLUMN($B$4))) turns the rows to columns. The rotated data is finally output via the INDIRECT function. Press ENTER. Drag the cursor in the lower right corner of the chosen ce...
Cursor "box" on active cellHome Board Archive Index Excel VBA Cursor "box" on active cell Posted by Jim on December 07, 2001 11:09 AM What vba code sets, for the lack of a better word"cursor box" to the active cell, and what's true nameThanksPosted by Dan on December 07, 2001 ...