ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Getting a position XY (range) on a matrix (https://www.excelbanter.com/excel-discussion-misc-queries/150367-getting-position-xy-range-matrix.html)

Jepane

Getting a position XY (range) on a matrix
 
Hi.

Im quite stuck here and would appreciate some help

Im trying to get in a macro a variable that contains the range of the
lower-right element of a variable matrix.

I developed a program that displays a table of variables X's and Y's but now
i need to identify the range of the last element on the displayed table.

I think it has to do with the "location" property but I've never used it

Thank you a lot in advance

Jepane


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com