Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping problem
When i click cancel it comes up with an error "Run time error'13', type mismatch" Here is my code so far Private Sub Worksheet_Activate() Call TripsCopy End Sub Sub TripsCopy() Dim Trips As Integer Dim tr As Integer Trips = InputBox("Enter no. of trips") If Trips 1 Then 'Sheets("Individual Trip").Select For tr = 1 To Trips Sheets("Individual Trip").Copy After:=Sheets(Sheets.Count) Next End If End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping problem
When you select cancel trips has the value = "", which is not an integer.
Change the declaration of trip to be: Dim trips as variant and this problem is solved! "Ewing25" wrote: When i click cancel it comes up with an error "Run time error'13', type mismatch" Here is my code so far Private Sub Worksheet_Activate() Call TripsCopy End Sub Sub TripsCopy() Dim Trips As Integer Dim tr As Integer Trips = InputBox("Enter no. of trips") If Trips 1 Then 'Sheets("Individual Trip").Select For tr = 1 To Trips Sheets("Individual Trip").Copy After:=Sheets(Sheets.Count) Next End If End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping problem
Okay i changed it and its still giving me the same error.
"Mike H." wrote: When you select cancel trips has the value = "", which is not an integer. Change the declaration of trip to be: Dim trips as variant and this problem is solved! "Ewing25" wrote: When i click cancel it comes up with an error "Run time error'13', type mismatch" Here is my code so far Private Sub Worksheet_Activate() Call TripsCopy End Sub Sub TripsCopy() Dim Trips As Integer Dim tr As Integer Trips = InputBox("Enter no. of trips") If Trips 1 Then 'Sheets("Individual Trip").Select For tr = 1 To Trips Sheets("Individual Trip").Copy After:=Sheets(Sheets.Count) Next End If End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping problem
Change
If Trips 1 Then To If Trips < "" And Trips < 0 Then "Ewing25" wrote: Okay i changed it and its still giving me the same error. "Mike H." wrote: When you select cancel trips has the value = "", which is not an integer. Change the declaration of trip to be: Dim trips as variant and this problem is solved! "Ewing25" wrote: When i click cancel it comes up with an error "Run time error'13', type mismatch" Here is my code so far Private Sub Worksheet_Activate() Call TripsCopy End Sub Sub TripsCopy() Dim Trips As Integer Dim tr As Integer Trips = InputBox("Enter no. of trips") If Trips 1 Then 'Sheets("Individual Trip").Select For tr = 1 To Trips Sheets("Individual Trip").Copy After:=Sheets(Sheets.Count) Next End If End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping problem
works perfectly thanks!
"Mike H." wrote: Change If Trips 1 Then To If Trips < "" And Trips < 0 Then "Ewing25" wrote: Okay i changed it and its still giving me the same error. "Mike H." wrote: When you select cancel trips has the value = "", which is not an integer. Change the declaration of trip to be: Dim trips as variant and this problem is solved! "Ewing25" wrote: When i click cancel it comes up with an error "Run time error'13', type mismatch" Here is my code so far Private Sub Worksheet_Activate() Call TripsCopy End Sub Sub TripsCopy() Dim Trips As Integer Dim tr As Integer Trips = InputBox("Enter no. of trips") If Trips 1 Then 'Sheets("Individual Trip").Select For tr = 1 To Trips Sheets("Individual Trip").Copy After:=Sheets(Sheets.Count) Next End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping problem | Excel Programming | |||
Looping Problem | Excel Programming | |||
Looping problem........ | Excel Programming | |||
Looping Problem | Excel Programming | |||
Looping Problem | Excel Programming |