VBA Row Function
Resolved · Low Priority · Version 2003
For upcoming training course dates see: Pricing & availability
RE: VBA Row Function
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
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
London & UK
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.