I have 6 spreadsheets that all have different ranges of data. I took the largest and wrote a macro hoping that when I applied the macro to the other sheets it would work, but because the data ranges are different, the macro does not perform or capture the data correctly. I was wondering if there is a command that can be inserted into the VB script that would allow the macro to auto expand the range depending on the data content of each spreadsheet.

Thanks