Hello,
I am trying to learn how to use input boxes so I have the code below, just something simple to insert a large number of rows.
How can I set up an input box where it asks the user which range they would like to insert rows? Thank you !
Sub InsertRows()
'
' InsertRows Macro
Range("A1:A25").Select
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
End Sub
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
TIP: There are all sorts of code snippets you can find by doing a search for something like Excel VBA prompt for range. You'll often find very good step-by-step guides with explanations.Originally Posted by DKsmash2014
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks