hey all,
Have some code that saves the one sheet as a new workbook which is cool. However I’d like to utilise a For – If loop to save every worksheet in that range to a new workbook.
Sub SaveSheet()
'
'Save single sheet as new workbook
'
Dim rcell As Range
Dim Background As Worksheet
Set...