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!

  • Congratulations Mike Lewis 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. THogan

    Photo Editor Not opening properly

    Hi there. Is it possible to right-click the start-bar icon for photo-editor, and select maximize? I've had this with office 97 version, where it looks like it hasn't started, but actually it has...it's just minimized to the task bar. If this is some other problem - many apologies.
  2. THogan

    Windows XP locking up on a newly built system

    are you running zonelarm 5?
  3. THogan

    change print spool location

    Click Start/settings/Printers File menu, Server properties, advanced tab Type a new folder path in the 'Spool folder' textbox (You will need to create the folder first, if it doesn't already exist...)
  4. THogan

    Insert blank line in Excel after certain criteria using VB.

    I've tested my code on the following: G4 = FISC G5 = 23 G6 = 45 G7 = 100 G8 = 700 G9 = 701 and it inserts a blank row at G9 (between 700 and 701). What are you testing it with? Have you copied the code verbatim (and just edited the start cell to G4 from A1)?
  5. THogan

    Insert blank line in Excel after certain criteria using VB.

    Of course - you'll need to add your own error handling and you might want to turn off screen updating while its processing...
  6. THogan

    Insert blank line in Excel after certain criteria using VB.

    Private Sub CommandButton1_Click() Dim lngValue As Long Range(&quot;A1&quot;).Select 'active cell at column heading FISC lngValue = 0 Do While lngValue <= 700 ActiveCell.Offset(1, 0).Select lngValue = ActiveCell.Value Loop 'activecell is now on the first row where value is...
  7. THogan

    Insert blank line in Excel after certain criteria using VB.

    Code to insert a blank row in excel from vb: ActiveCell.EntireRow.Insert
  8. THogan

    MCAFEE DELETING OUTLOOK EXPRESS EMAIL

    Had this problem too. Occured with Outlook Express 6 on my WinXP machine, running McAfee 4.5.1 Only way I could fix it was to upgrade to VS7E. See http://www.theregister.co.uk/content/archive/22508.html for a better explanation, and a workaround involving setting 'compact databases in...

Part and Inventory Search

Back
Top