I am using a TAdvGridWorkbook to allow for me to have multiple sheets. I assume that the grids work in the same manner as a standalone TAdvStringGrid, but I can't seem to be able to highlight multiple cells or select a range (even though goRangeSelect is set to true within the grid).
Is editing enabled in the grid? (goEditing = true in grid.Options)?
If so, then set grid.MouseActions.RangeSelectAndEdit = true
Yes, this fixed it.
Once grid.MouseActions.RangeSelectAndEdit was set to true I could then perform range select.