Formatting numbers with vba

I have written the following code to fill m sheet with data and then format the range of the data to remove the decimals.

Please Login or Register  to view this content.

The sub PasteDownN is simply a routine to copy and paste a row of formulae to a range and then change that range to values


I get the error message "unable to set the NumberFormat property of the Range Class" at the line marked "xxxxxxxxx"
I cant find why. I am sure that NumberFormat is a property of Range but perhaps I am wrong. Can somebody help please?
John

Does the PasteDownN sub re-apply protection?

Fluff13
Yes it does. Is the protection the problem?

Hard to tell without seeing the data, especially .Range("H10:S65"). Are these ranges formatted with something other than a number? The syntax is solid.

Well, that was straight forward enough!
Many thanks for your help it seems obvious now but I had tried many options for hours without success.
John

Glad it's sorted & thanks for the feedback.