vba row function
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA Row Function

VBA Row Function

resolvedResolved · Low Priority · Version 2003

Thu 17 Dec 2009, 16:11 replyReply Delegate Tony said...

VBA Row Function

How do you delete rows using a variable.
Rows("1:5").delete
works but how do you use a variable name

For upcoming training course dates see: Pricing & availability

Fri 18 Dec 2009, 09:08 replyReply Trainer 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 Sub


Regards

Stephen

 

Please browse our web site to find out more about
excel consultant and other Microsoft training courses.

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips



Excel training
Course rating
4.7 stars - based on 18023 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom