I'm just learning how to use VBA/Macros, and i have one macro referring to another macro. when the file is copied/renamed it tries to refer to the original file. I removed the file name from the macro and now steps through, but i get error 1004 "cannot use that command on overlapping sections....
Could questions, how do i go about getting these macros consolidated? & How do i tell what is overlapping? I there's only one range & no merged cells.
The PTSSheet2() - is to remove empty rows from copied worksheet
The SimbadS()-is to copy/paste a hidden reference worksheet
Sub PTSSheet2()
'
' PTSSheet2 Macro
'
'
Application.Run "SimbadS"
Range("A3:G60").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
Sub SimbadS()
Dim Ws As Worksheet
Set Ws = Sheets("Pts template")
Ws.Visible = xlSheetVisible
Ws.Copy
With ActiveSheet.UsedRange
.Value = .Value
End With
Ws.Visible = xlSheetVeryHidden
End Sub
Bookmarks