Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All. I have the following code for a UserForm. It copies a list of dropped
golfers, goes to another part of the spreadsheet and finds the 1st empty cell in the column, pastes it and then moves 1 cell to the right and enters the date. All that works fine. The problem is that after it completes that it doesn't go to macro "DropButtonContinue". It loops again. Can anyone tell me what I am missing? Private Sub DropButton_Click() Range("DROPS").Select Selection.Copy strDrops = Range("TEAMDROPS").Value Range(strDrops).Select For DropsCounter = 1 To 100 If ActiveCell.Value = "" Then Selection.PasteSpecial Paste:=xlValues Application.CutCopyMode = False ActiveCell.Offset(0, 1).Select ActiveCell.Value = Date DropButtonContinue Else ActiveCell.Offset(1, 0).Select End If Next DropsCounter End Sub Private Sub DropButtonContinue() <<<More Code Here Thanks for any help. -- Jim T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Call Macro | Excel Discussion (Misc queries) | |||
How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
Excel Macro call Word Macro with Parameters | Excel Programming | |||
Call macro stored in Excel workbook from Outlook's macro | Excel Programming |