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 strongm 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. 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...

Part and Inventory Search

Back
Top