Thread: paste as value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default paste as value
Hi
try
with range(A1:A100)
.value=.value
end with

--
Regards
Frank Kabel
Frankfurt, Germany

"Tang" schrieb im Newsbeitrag
...
how to convert a text into value using VBA for a range.



Reply With QuoteReply With Quote