I want to change this code (that I copied of the net) so that instead of asking for the number of rows the macro gets that information from a cell in another worksheet.
If vRows = 0 Then
vRows = Application.InputBox(Prompt:= _
"How many rows do you want to add?", Title:="Add Rows", _
Default:=1, Type:=1) 'Default for 1 row, type 1 is number
End If
Worksheet stafflist
Col A Col B
Number of Teachers 4
Worksheet payroll
add 3 rows below teacher information row so that I go from having one teacher to having four teachers.
I hope this is understandable.
Terri
If vRows = 0 Then
vRows = Application.InputBox(Prompt:= _
"How many rows do you want to add?", Title:="Add Rows", _
Default:=1, Type:=1) 'Default for 1 row, type 1 is number
End If
Worksheet stafflist
Col A Col B
Number of Teachers 4
Worksheet payroll
add 3 rows below teacher information row so that I go from having one teacher to having four teachers.
I hope this is understandable.
Terri
