title: Excel-VBA: How to get size of selected array in vba code?
body: <p>i'm writing an vba function in excel which takes in an odd sized empty square matrix and filling it with numbers. However, I can't get to retrieve the size of the array that it dynamically selected in the spreadsheet before the function is called. How would I do this?</p>
  
  <p>Thanks!</p>