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 Rhinorhino 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 tonybarr007

  1. tonybarr007

    Transpose Data in VBA

    Thanks bd that was exactly what I needed, and No worries Skip.
  2. tonybarr007

    Transpose Data in VBA

    This code was submitted as to how to paste into the first available row. If I wanted to transpose the paste and keep only the value and number format, where do I enter that into the code below? (i.e.Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone...
  3. tonybarr007

    Creating a Macro that enters data under last row that data was entered

    Below is the current code, It works fine for the first line but I am unaware of how to specify the range that rather than being "A3:H3" it will copy the data from Sheet 2 "B2:B9" and insert into the next row. please help. Sub Macro1() ' ' Macro1 Macro ' Macro recorded 6/12/2007 by Anthony...
See more

Part and Inventory Search

Back
Top