Transpose a range in VBA

by

This gets you X and X’ as variant arrays you can pass to another function.

Dim X() As Variant
Dim XT() As Variant
X = ActiveSheet.Range("InRng").Value2
XT = Application.Transpose(X)

To have the transposed values as a range, you have to pass it via a worksheet as in this answer. Without seeing how your covariance function works it’s hard to see what you need.

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. Refer to sheet using codename
  4. VBA macro that search for file in multiple subfolders
  5. VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Getting ScriptControl to work with Excel 2010 x64
  8. Application.Match gives type mismatch
  9. Count and Highlight keywords within phrases
  10. Get list of Excel files in a folder using VBA [duplicate]
  11. Select first empty cell in column F starting from row 1. (without using offset )
  12. How to “flatten” or “collapse” a 2D Excel table into 1D?
  13. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  14. Excel VBA: AutoFill Multiple Cells with Formulas
  15. VBA.Find and adding a value
  16. excel vba- extract text between 2 characters
  17. Round function in Excel, worksheet function vs VBA
  18. How to continue the code on the next line in VBA
  19. Excel VBA Userform – Execute Sub when something changes
  20. Count the number of rows in another sheet [duplicate]
  21. Getting Excel to refresh data on sheet from within VBA
  22. VBA Password Input with Cancel Function
  23. Finding first blank row, then writing to it
  24. Calling regasm without administrative rights for COM interop in Excel VBA
  25. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  26. How do I activate a specific workbook and a specific sheet?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment