Hey guys, I need some help with the wording for a line of code ...
Info is imported from one spreadsheet to this one. There will always be info in Columns A:D, but the number of rows always varies. Data is contiguous throughout Column A, but that is not true for all other columns. I want to write a code that always selects the next to last cell with data in Column A, to cell D2. In other words, for this particular scenario, I would want the range selected to be A6:D2. If data in Column A were to go to cell A200, I would want the range selected to be A99:D2 ... if data went to cell A1000, I would want the range selected to be A999:D2, etc. I know this will probably be a very simple answer, but what would the Range code look like for this? Thanks!
Bookmarks