Populate a default value in excel macro

[Azhar]

Hi forum,
i want to populate a column with default value in excel macro

Example: for column J the value should be RYD i.e. the column J should be defaultly populated with value RYD.

Thanks
Azhar

 

[VoG]

Like this?

Range("J1:J100").Value = "RYD"

 

[Azhar]

will this populate my column with default value as RYD?

 

[VoG]

It will write RYD in J1:J100. I don't know what you mean by "default value".

 

[Azhar]

Requirement is for the column J, the value should be only RYD. no other values should be allowed other than RYD in the J column.

 

[VoG]

Use Data Validation Apply data validation to cells - Excel