Ok..I've tried several time to get something working here. I'm looking to insert an error trap that will display a msg that "The number of entries has been exceeded" This will happen when the user tries to build something with more that 40 lines of entries. I've pasted the section of code where I think it should go...any input will insure good Karma!!
Application.ScreenUpdating = False
With Sheets("RecipeCard")
.Range("A12:F60").Value = Sheets("RecipeTracker").Range("P11:U300").Value
With .Range("A12:A60")
.Replace What:="0", Replacement:="", LookAt:=xlWhole
.SpecialCells(xlBlanks).EntireRow.Delete
End With
End With
Application.ScreenUpdating = False
With Sheets("RecipeCard")
.Range("A12:F60").Value = Sheets("RecipeTracker").Range("P11:U300").Value
With .Range("A12:A60")
.Replace What:="0", Replacement:="", LookAt:=xlWhole
.SpecialCells(xlBlanks).EntireRow.Delete
End With
End With