Copy Visible Range To A New Workbook

less than 1 minute read Copies only the visible cells in a selected range to a new workbook, a A1 ‘================================================================================================== ‘ ## Copy range to a new workbook, only copies the visible cells in the selected range ‘================================================================================================== Sub RangeToNewWorkbook() ‘// Vars Dim shtNew As Worksheet Dim rngSelection As Range ‘// Optimise Application.ScreenUpdating = … Read more