Column 1 is already set. Column 2 must check for divisibility of 2 and display "yes" if divisible and nothing if not. Same for column 3 checking for divisibility of 3. Here is what I have.
Sub Divisible()
'this macro determines if a number is divisible by 2 or 3
For rowcounter = 1 To 100
Cells(rowcounter, 1).Value = rowcounter 'column 1 has 1,2,3,...
Next rowcounter
End Sub
Bookmarks