| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep original cell formatting when using transpose array formula
No, no, and no! Sorry, but everything you want to do requires VBA. The
only reason the formatting transposed with PasteTranspose is because it tagged along with Copy. Your 2nd request also requires VBA and you'd have to specify what order would you like the colors sorted to. Is there some reason you can't pre-format the cells with the TRANSPOSE formula? -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to re-initialize cell with original formula | Charts and Charting in Excel | |||
| Original cell formatting clears when I move contents | Excel Discussion (Misc queries) | |||
| formula copies value from original cell only | Excel Worksheet Functions | |||
| Can I keep the original cell formatting when using FILL? | Excel Discussion (Misc queries) | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
