Hello,
I'm kind of a noob to VBA, but I am trying to write a macro using a variable last row definition (lngLastRow). I've done this before and have had success, but this time the code is not defining the correct last row. Here are the important specifics (as I see them):
In a worksheet, I am subtotalling data by a column heading. From there I am copying and pasting visible cells in the same worksheet to the right of the data. Then, I am removing the subtotals and deleting the columns that held the original data. Finally, I am using the lngLastRow dimension to define the last row of data. The result is that the last row is being defined by the number of rows in the original table (before I subtotalled the data) instead of the pasted visible rows.
How do I properly define the range I am looking for?
Thanks in advance.
Bookmarks