How can you read with a VBA Excel Sub a vector from the worksheet?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • akindofmagic
    New Member
    • Sep 2010
    • 1

    How can you read with a VBA Excel Sub a vector from the worksheet?

    Let's say I have a worksheet in Excel. The purpose of the Sub is to read various vectors through an InputBox, without the Sub asking the user the number of elements for that vector.
    I assume:
    Code:
    Sub vect()
      Dim aVector as Range
      Set aVector = Application.InputBox = ("Vector range", type:=8)
      ' Display the vector trough Debug.Print
    End Sub
    Thank you. Stefan
Working...