Error Occur when write .Range Code

Please read the forum rules. Code tags are required when posting VBA code.
You need to edit your thread and add the code tags.

First, remove the quotes from around the code, then select the code and click the button with the # symbol.

Just guessing since you didn't post all of your code.

You have

Please Login or Register  to view this content.

Looks like you need

Please Login or Register  to view this content.

Notice that the >[ . ]< is removed

Without seeing all of your code, it's hard to say. If you really meant to use [ . ], are you using the With/End With statement and have you fully qualified the sheet reference for the range object?

Here is the coding i work for it prompt out the message

Please Login or Register  to view this content.

Hello gingank,

The period character indicates that either an object, method or property follows after it. If nothing precedes the period then VBA looks for a "With" statement. Here is the code written with a "With" statement.

Please Login or Register  to view this content.