I am copying a range of data of one worksheet to a new workbook. I only want to copy the range and convert formulas to data. I am sure there are more clever ways... but this will get the job done for now.
However I need to copy over one NamedRange or create the same named range.
Could someone point out how to do this? The namedrange is "TotalRow" and is =FF!$A$133:$AG$133
[VBA]
Range("A1:AF133").Copy
Application.CutCopyMode = False
'Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Columns("A:A").ColumnWidth = 2
Columns("B:E").EntireColumn.AutoFit
Columns("F:J").ColumnWidth = 11
Columns("K:AF").EntireColumn.AutoFit
Rows("1:6").RowHeight = 14.25
[/VBA]
Thanks,
YLP