G
Guest
Guest
I have the following macro: RowNum = Application.InputBox(Prompt:="Number you want to insert ?", Type:=1)
Rows(RowNum).EntireRow.Insert
Rows(RowNum).Select
RowNum = Application.InputBox(Prompt:="What is the name ?", Type:=2)
End If
Range("A16") = InputBox("Input text to go in A16")
My question: In this case I have insert row 16,but what if this is 25.Do I have to change everytime this macro with Range("A25")
Can this not be variable.
Rows(RowNum).EntireRow.Insert
Rows(RowNum).Select
RowNum = Application.InputBox(Prompt:="What is the name ?", Type:=2)
End If
Range("A16") = InputBox("Input text to go in A16")
My question: In this case I have insert row 16,but what if this is 25.Do I have to change everytime this macro with Range("A25")
Can this not be variable.