Copy and Paste Values as Number Format

Hello,

I am trying to write a Macro where it will use date and time (protected fields), and copy and paste values in number format (not general) for only fields that have a formula. I believe I am close, but I keep getting a debug error ~1004 on the third to last line (NumberFormat). Any help would be appreciated.

Please Login or Register  to view this content.

Hi Daniel,

I think you're getting the error when the sheet is protected when you access the line:

Please Login or Register  to view this content.

There does not seem to be an error when the sheet is NOT protected when you access the line.

I can't suggest a fix, because I'm not sure what you're trying to do.

Lewis