loops

  1. K

    MS Word macro

    Hi. I'm having problems with this one Sub Macro1() ' ' Macro1 Macro ' ' Selection.HomeKey Unit:=wdStory Do While Selection.Find.Execute = True Selection.Find.ClearFormatting Selection.Find.Font.Color = wdColorAutomatic With Selection.Find .Text = "EXAMPLE1"...
  2. S

    Solved Excel VBA Looping Blues

    Hello All - I have written a subprocedure that attempts to loop through all worksheets in an Excel file and export the data to one Access table (I'm using Office 2010). There are 18 worksheets, each having exactly 100 records. When I run the subroutine, 1800 records are added to the Access...
Top