Use Application.Transpose:
Function vCP(v1 As Variant, v2 As Variant) As Variant vCP = Application.Transpose(Array(v1(2) * v2(3) - v1(3) * v2(2), _ v1(3) * v2(1) - v1(1) * v2(3), _ v1(1) * v2(2) - v1(2) * v2(1))) End Function
Related Posts:
- C++ compile time error: expected identifier before numeric constant
- MS Excel Scatterplot converts Months to Numbers
- Substring in excel
- How to implement 2D vector array?
- IndexError: too many indices for array
- IndexError: too many indices for array
- What does <> mean?
- What is the easiest way to initialize a std::vector with hardcoded elements?
- Vector of Vectors to create matrix
- Excel to Google Sheets – Error: Formula parse error
- How to find out if an item is present in a std::vector?
- How do I print out the contents of a vector?
- ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
- numpy matrix vector multiplication
- check if a std::vector contains a certain object?
- Counting the number of elements with the values of x in a vector
- How to navigate through a vector using iterators? (C++)
- C++ for each, pulling from vector elements
- IndexError: too many indices for array
- Swap x and y axis without manually swapping values
- How do I erase an element from std::vector<> by index?
- Excel: Calculate the frequency of a particular month in a column of date cells
- How to print elements in a vector c++
- Is it more efficient to copy a vector by reserving and copying, or by creating and swapping? [duplicate]
- Calculating a 2D Vector’s Cross Product
- How do I reverse a C++ vector?
- Are vectors passed to functions by value or by reference in C++
- Debug assertion failed. C++ vector subscript out of range
- No matching member function for call to ‘push_back’ error
- Pass a vector by reference C++
- Why there is no pop_front method in C++ std::vector?
- Initializing a two dimensional std::vector
- C++ – No matching member function for call to ‘push_back’
- Looking for a clear description of Excel’s .xlsx XML format
- Help needed with Median If in Excel
- Debug assertion failed. C++ vector subscript out of range
- Invalid column count in CSV input on line 1 Error
- Vector is not a Template?
- How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
- Displaying a vector of strings in C++
- Invalid column count in CSV input on line 1 Error
- How to find a value in an excel column by vba code Cells.Find
- ‘vector’ in namespace ‘std’ does not have a template type
- How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
- C# equivalent of C++ vector, with contiguous memory?
- Object Required Error in excel VBA
- C++ error: Undefined symbols for architecture x86_64
- excel IF formula Error, “You’ve entered too many arguments”
- Vector of structs initialization
- Converting a vector
to string - Insert picture into Excel cell
- vector
::size_type in C++ - Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
- What is a correct MIME type for .docx, .pptx, etc.?
- Is there Infinity in Spreadsheets?
- How to fix file format and extension don’t match?
- Declaring variables in Excel Cells
- Why use a new call with a C++ ‘vector’?
- What are .NumberFormat Options In Excel VBA?
- Why doesn’t std::vector::push_front() exist?
- C++ delete vector, objects, free memory
- How to iterate over a vector?
- How to access the contents of a vector from a pointer to the vector in C++?
- Better way to find last used row
- VBA, if a string contains a certain letter
- Insert object at index of vector c++
- Visual C++ find line causing “Debug Assertion failed”
- How to loop in excel without VBA or macros?
- How can I open an Excel file in Python?
- How to convert vector to array
- ValueError: cannot index with vector containing NA / NaN values
- No operator << matches these operands
- Initialize empty vector in structure – c++
- Excel VBA Macro: User Defined Type Not Defined
- splitting a string into an array in C++ without using vector
- How can I import an Excel file into SQL Server?
- What is correct content-type for excel files?
- How do I get countifs to select all non-blank cells in Excel?
- How to run a SQL query on an Excel table?
- What is the function of FormulaR1C1?
- VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
- What exactly is the function of Application.CutCopyMode property in Excel
- What’s the most efficient way to erase duplicates and sort a vector?
- Best way to extract a subvector from a vector?
- How to sum up elements of a C++ vector?
- Implementation of Vector in C++
- Excel – SUMIFS for multiple columns
- Appending a vector to a vector
- Workaround for “Formula omits adjacent cells”
- Select method of Range class failed via VBA
- How to initialize a vector of pointers
- Does VBA contain a comment block syntax?
- VBA Excel – Insert row below with same format including borders and frames
- ImportError: No module named win32com.client
- Is it possible to force Excel recognize UTF-8 CSV files automatically?
- Why does “Paste Method of Worksheet class failed” occasionally occur?
- C++ Erase vector element by value rather than by position?
- Excel Filters – show only relevant values in the filter
- Linked List vs Vector
- check if a file is open in Python