paste as value

[Tang]

how to convert a text into value using VBA for a range.

 

[Frank Kabel]

Hi
try
with range(A1:A100)
.value=.value
end with