Hi,
I would like to know if is possible to select the whole data set i.e. like below as the size of the data set might change and then set it as an array?
activesheet.Range("a1", _
activesheet.Range("a1").End(xlDown).End(xlToRight))
Also, once the array is set, is it possible to return a value from a certain cell to the activecell?
i.e. activecell is P1 but i want the cell value to be = to a1? Thanks.
I would like to know if is possible to select the whole data set i.e. like below as the size of the data set might change and then set it as an array?
activesheet.Range("a1", _
activesheet.Range("a1").End(xlDown).End(xlToRight))
Also, once the array is set, is it possible to return a value from a certain cell to the activecell?
i.e. activecell is P1 but i want the cell value to be = to a1? Thanks.