-
FlexPro
- Zoom sur FlexPro
- Fonctionnalités & Options
- Domaines d’application
- Tous les avantages
- Nouveau dans FlexPro 2021
- Testez FlexPro gratuitement
- FlexPro View OEM Freeware
- Conseils d’achat
- Login
- Langue
-
-
-
- +49 6894 929600
- infoweisang.com
- Google Maps
- Produits
- News
- Support
- Société
- Emplois
- Contact
- Login
- Langue
-
-
-
- +49 6894 929600
- infoweisang.com
- Google Maps
Accueil > Community > Automation and VBA > Copy a matrix into excel > Reply To: Copy a matrix into excel
January 8, 2016 at 10:43 am
#9422
![Bernhard Kantz](https://www.weisang.com/wp-content/uploads/2016/09/default_avatar.jpg)
Participant
Your code should work if you assign the value of the formula evaluation instead of the value object itself to your matrix variable.
Dim fml As Formula
Set fml = ActiveDatabase.RootFolder("Formel", fpObjectTypeFormula)
fml.Update
Dim matrix
matrix = fml.Value
Note the update of the formula before using its value.
Hint: To exchange rows and columns use Application.WorksheetFunction.Transpose(matrix) in the assignment to the range.