Hi all,
I have a global variable, FinalRow, which calculates the finalrow of the records in the Worksheet_Activate event.
The global variable is declared in a module.
I created a button and assigned a macro (below) to it to allow users to view the records. I used an array in it.
Sub...