>I am trying to do some calculations in a grid.
>I am using it a little like a spreadsheet.
>
>However I notice that as I move around my grid the Grid.Activerow
>and the grid.relativerow always appear to read zero.
>
>I need these poperties to work because I am hoping to use the Activatecell(nrow,nCol) method and it will need the right co-ordinates to work.
>
>I have been forced into trying to do it this way because I tried doing my calculations on the underlying table but could not get my grid to refresh with the new data, so if someone knows how I can get the grid to refresh. (grid.refresh does not work) then I may be saved having to sort out the above problem.
>
>
>Many Thanks
Mark,
Grid active* and relative* are nonzero when focus on grid. However they're zero between some events. I should warn you using them you force your grid to work slower.
Probably you don't even need a refresh. It depends on type of calculation. More clue on that pls :)
Cetin