Unstable Copy and Paste formulas

[LoftySuth]

My problem concerns the HP4550 sheet in the attached workbook.
This sheet ,which is one of 3 similar sheets, consists of a series of named ranges called "HP4550_Formulasn" where n is an integer and another series of named ranges called "HP4550_Resultsn"
The procedure called PasteDownN in the Module "Functions" causes the Ranges "HP4550_Formulasn" to be copied and pasted into the corresponding Results range and then the results range to be copied and pasted as values. This is a technique I learned years ago and I use usually on much bigger tables to keep workbooks down in size.
My problem is that the copying and pasting of the formulae is happening haphazardly, so that perhaps only one column out of three pastes down. This happens on several tables , but most frequently on 15. 16 and 17.
When I try to carry out the procedure manually I find that selecting the formula row with a mouse is also haphazard and instead of the whole row being selected, perhaps only one or two cells are selected. This happens mostly on sheet "HP4550" but does happen on the other two (not sent with download).If I keep dragging the mouse over the formula range iI can eventually select it and the copying and pasting then works normally.
I am concerned in case this is a windows fault (Windows7) or maybe an Excel2007 fault. I would be grateful for some guidance.
John