Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. oziric

    My "do-loop" skips the center of the macro

    Hi Your code was OK it only needs the following change :-) Sub Macro3() Do Until IsEmpty(ActiveCell.Value) 'runs down until it hits a blank cell If ActiveCell.FormulaR1C1 = "#N/A" Then ActiveCell.FormulaR1C1 = "=TODAY()" End If ActiveCell.Offset(1, 0).Range("A1").Select...

Part and Inventory Search

Back
Top