98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Row Function
VBA Row Function
Resolved · Low Priority · Version 2003
Thu 17 Dec 2009, 16:11Delegate Tony said...
Tony has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Intermediate course
Access Advanced course
VBA Row Function
How do you delete rows using a variable.
Rows("1:5").delete
works but how do you use a variable name
Fri 18 Dec 2009, 09:08Trainer Stephen said...
RE: VBA Row Function
Hi Tony
Thanks for your question
The following code prompts the user to enter a start and finish row and then cocatenates them into a string that is used in the delete method
Sub RowDeleter()
Dim intStart As Integer
Dim intFinish As Integer
Dim strDelete As String
intStart = InputBox("Enter Start Row")
intFinish = InputBox("Enter Finish Row")
strDelete = intStart & ":" & intFinish
Rows(strDelete).Delete
End SubRegards
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move data worksheet to worksheetTo move data from one worksheet to another, highlight the data. |
