Hi All,
I'm writing some VBA in which I need to get the row indices of all the rows in a spreadsheet whose column A contains a particular value, how might I do this?
Also is there a way I can assign all the values of cells in a row to an array? Such that the first element of the array would contain the value of column A, the second element the value of column B and so on.
All help will be much appreciated.
Bookmarks