you cant.

you can:
hold an array in memory
manaipulate values in array
write array to cells
then format cells.

reserve a range in a sheet
manipulate values and formats in that range
copy the range to destination.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Juggernath wrote :

How to put values into the clippboard in macro but with defined
formats etc? I have array of input data which i access via selection
property. That data are processed and now i have to put array of
results in clippboard. After macro ends its work, I'd like to select
any part of a worksheet and then paste an array of formated result
data