Definition dynamic minverse

Discussion in 'Excel' started by georgelampiris, Dec 14, 2017.

  1. georgelampiris

    georgelampiris

    Joined:
    Dec 14, 2017
    Messages:
    1
    Likes Received:
    0
    I have the following code. Is there anyone who can help me? There is a problem with the range definitions

    Sub array13()
    Dim x As Integer, k As Integer
    x = InputBox("give the range")
    Sheets("perifA").Select
    Range("A1").CurrentRegion.Select
    gram = Selection.Rows.Count
    stiles = Selection.Columns.Count
    Sheets("Leontief").Select
    Range(Cells(1, 1), Cells(gram, stiles)).Select

    Selection.FormulaArray = "=MINVERSE(perifA!Range(cells(1,1),cells(x,x)))"

    End Sub
     
    georgelampiris, Dec 14, 2017
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.