Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to set up a macro to help search through a column of numbers to
find out which two (or more) add to an input number, and then show the numbers in a box. I'm starting with a basic loop that I've used before and I can't get it past the Do While point. Can anyone tell me what I'm missing? Sub Find_Combos_That_Add_to_Input_Value() 'Start at the currently selected cell Dim x As Integer x = ActiveCell.Row 'Loop Do While Cells(x, 0).Value < "" 'If the values of the first row plus the next row equal the input number 'show the message, otherwise go to the next row until the end If (Cells(0, 0).Value + Cells(x, 0).Value = 5) Then MsgBox ("Values are" & Cells(0, 0).Value & "and" & Cells(x, 0).Value) Else 'increase the value of rownum by 1 to move the loop starting point to the next row End If x = x + 1 Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel macro/vba loops | Excel Programming | |||
macro that loops till end of worksheet | Excel Programming | |||
Vlookup macro that returns data from worksheet, then Loops | Excel Programming | |||
copying areas and macro loops | Excel Programming | |||
macro that loops to multiple columns | Excel Programming |