Cannot assign the NumberFormat property of the Range class

[zelarra821]

Good afternoon.

I'm trying to format some cells, but I get the error that you can see in the title: Cannot assign the NumberFormat property of the Range class

I don't know what I'm doing wrong, if someone could guide me.

Please Login or Register  to view this content.

Thanks.

[TMS]

HTML tags don't work very well. Please use Code Tags. As it stands, we can't see your code.

[zelarra821]

I don't know how to put it in any other way than that so that it can be seen.

[TMS]

Take out the .Text. .NumberFormat can't be applied to Text.

[TMS]

I don't know how to put it in any other way than that so that it can be seen.

Administrative Note:


We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[zelarra821]

Not even with those, it keeps giving me the error.

[zelarra821]

It's alredy done it

[TMS]

The Code tags are to fix your post, not the problem. See post #4.

[TMS]

This is getting silly. Post your workbook.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[zelarra821]

You got it

[zelarra821]

If by the way you suggest me how I can improve the code to optimize it, much better.

[zelarra821]

The sub is named Formatear

[TMS]

This is what I meant:

Please Login or Register  to view this content.

I can't test this as I don't know how to drive it. You do know that having the Worksheet_Activate Event handlers can mean you can't copy between sheets.

[zelarra821]

https://www.dropbox.com/s/la8b5okq7v...Video.avi?dl=0

If you press the Formatear button, it will give you the error. If you put two dates in D4 and E4, and press Formatear again, it will give you the error. It's on line 105 of the module.

[zelarra821]

Solved. There was a problem with protected sheets. Thanks to all.