Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting an array
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 -- mickiedevries ------------------------------------------------------------------------ mickiedevries's Profile: http://www.excelforum.com/member.php...o&userid=10869 View this thread: http://www.excelforum.com/showthread...hreadid=570880 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting an array
generally, if you want to copy formatting, you do a copy and paste.
An array (if you mean a VBA array) only holds values or formula - not formatting. -- Regards, Tom Ogilvy "mickiedevries" wrote: 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 -- mickiedevries ------------------------------------------------------------------------ mickiedevries's Profile: http://www.excelforum.com/member.php...o&userid=10869 View this thread: http://www.excelforum.com/showthread...hreadid=570880 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on a vertical Array. | Excel Worksheet Functions | |||
Conditional Formatting/Array Formula | Excel Discussion (Misc queries) | |||
Conditional formatting based upon array | Excel Worksheet Functions | |||
Conditional Formatting for Array containing Text | Excel Worksheet Functions | |||
Adding range to array, keep formatting | Excel Programming |