Definition dynamic minverse

Joined
Dec 14, 2017
Messages
1
Reaction score
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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top