View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mcg mcg is offline
external usenet poster
 
Posts: 18
Default Formatting an array


mickiedevries napisal(a):
My program takes information from a spreadsheet which is formated with
italics in some situations, and puts that information in an array, and
then adds it to a new worksheet.

I cannot figure out a way for my formatting to remain the same on the
end worksheet as it was on the worksheet it was taken from.

If there is a way please help!

Thanks!

Mickie


try
copy your data and
PasteSpecial Paste:=xlPasteFormats

i mean paste special-formats
where u want

mcg