Highlight Row and column trough cell number - Row selection, not color changing rows

[Tiago Ferreira]

Hi guys!.

So, i have spreadsheet with some code that track my mouse x and y positions, and then puts in cell A1 the row number and in cell A2 the column number correponding off my mouse position.

What i need now is to take this row and column numbers from this cells, and use it to select the corresponding rows and columns.


I have found code to color change the rows and columns, but what i want is to select the rows and columns, like when you press them, an example here:

Like this:

Not like this:

Thanks in advance

 

[hiker95]

Many thanks for your effort to help me

Tiago Ferreira,

You are welcome.

Sorry that I was not able to understand what you actually wanted.