ExcelBanter - paste as value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - paste as value (https://www.excelbanter.com/excel-programming/307587-paste-value.html)

Tang[_2_]

paste as value

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

Frank Kabel

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.

All times are GMT +1. The time now is 03:01 AM.