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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by phatmankerr2005

  1. phatmankerr2005

    Amlagamate Worksheets

    FaneDuru, Cheers mate have applied your new code - runs noticably faster. Thanks Phat
  2. phatmankerr2005

    Amlagamate Worksheets

    Skip, Cheers mate but I was really looking for a VBA solution - hit the books and came up with the following (if anybody's interested). Worked fine. Sub amalgamate() For i = 2 To Worksheets.count Worksheets(i).Activate ActiveSheet.Range("A1").Select ActiveCell.CurrentRegion.Select...
  3. phatmankerr2005

    Amlagamate Worksheets

    I need to be able to amalgamate seperate worksheet data into one single sheet (all the sheets contain the same headings) but I need all the data in one block (minus the headings if possible). Anybody any ideas how to do this simply. Only reason I ask is that I have 140 worksheets all with...
  4. phatmankerr2005

    Customise Word 2003 Right Click

    tf1, Thanks mate worked perfectly (has been bugging me for ages), see what you mean about the number of menu choices though ! Much appreciated phat
  5. phatmankerr2005

    Customise Word 2003 Right Click

    Is is possible to customise the Right Click Menu in Word 2003. Basically I want to add a 'Select All' item. I relaise you can use Ctrl+A but I am looking for a mouse friendly solution (and would also like to know how to customise the right click menu anyway). Any ideas much appreciated. Cheers
  6. phatmankerr2005

    View Field Codes State in VBA

    EarthandFire, Worked perfectly, many thanks. Why is this not in the VBA help file (sorry not another question just a statement). Thanks again
  7. phatmankerr2005

    View Field Codes State in VBA

    Is there anyway to determine the state of 'View Fields Codes' (as displayed using the Key combination Alt+F9) programatically in VBA and turn it on if it is off. Tried using Send Keys, but as this is a toggle it can all go horribly wrong. I want to combine this with a Multiple Document Search...
See more

Part and Inventory Search

Back
Top