Sam Jones Posted November 10, 2023 Share Posted November 10, 2023 What is the format for specifying the selection of a worksheet cell when there are no subrows in the worksheet, and even if there was, what would the format be for selecting a cell that is not part of a subrow? PROCEDURE SetWSSelection ( worksheet:HANDLE; currentCellRow:INTEGER; currentCellColumn:INTEGER; topRangeRow:INTEGER; leftRangeColumn:INTEGER; topRangeSubrow:INTEGER; bottomRangeRow:INTEGER; rightRangeColumn:INTEGER; bottomRangeSubrow:INTEGER ) ; I have tried not including any subrow specification, putting "0"s in the subrow specification, and putting the cell row, col values in the subrow specification. None of that works. Quote Link to comment
michaelk Posted November 10, 2023 Share Posted November 10, 2023 As far as I can tell the topRangeSubrow and bottomRangeSubrow always return 0 no matter what when using GetWSSelection. I'm able to select cells using 0 in those values. If there are subrows it always selects the header row. currentCellRow and currentCellColumn should be in the range of the topRangeRow,leftRangeRow,rightRangeRow,botttomRangeRow I've found that it may let you set (1,1,10,3,0,14,7,0) but you might be force quitting Vectorworks soon after. The only way I can see that a user could select a range of rows with a mouse would force currentCellRow,currentCellColumn to be equal to either topRangeRow,leftRangeRow or rightRangeRow,botttomRangeRow. Quote Link to comment
Sam Jones Posted November 10, 2023 Author Share Posted November 10, 2023 @michaelk I just want a command to select one worksheet cell, e.g. C12 Quote Link to comment
michaelk Posted November 11, 2023 Share Posted November 11, 2023 SetWSSelection(WSHand,12,3,12,3,0,12,3,0); Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.