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!

Search results for query: *

  • Users: marboa62
  • Order by date
  1. marboa62

    Copy formulas down using autofill

    Thanks to everybody ! Your hints helped me I got the solution Marins Spirit of Australia
  2. marboa62

    Copy formulas down using autofill

    Hi Skip, the routine suggested Range([Q3], [Q3].End(xlToRight)).AutoFill Destination:=Range(Cells(rStart,"Q"),Cells(rEnd,"Q")) does not work, stopping program for debugging I try also with Range([Q3], [Q3].End(xlToRight)).AutoFill Destination:=Range(Cells(rStart, 10), Cells(rEnd, 10))...
  3. marboa62

    Copy formulas down using autofill

    Ok Skip, having rStart and rEnd defined as you suggest how can I insert them in the last istructions Range("Q3").Select Selection.End(xlDown).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy rStart = [Q1].End(xlDown).Row + 1 rEnd = [P1].End(xlDown).Row Range (???)...
  4. marboa62

    Copy formulas down using autofill

    Answer for skip Excuse me Skip, in the first thread I try to explain the nature of my question Perhaps I was not clear How can you copy the formulas under down, reaching the rows where the left side of colums are filled. Recording the macro, the step is coded "Selection.Autofill...
  5. marboa62

    Copy formulas down using autofill

    Answer for anotherhiggins In "option" I have the right configuration. If I select the n colums and on the south-est give a double click, all formulas are copied under down, reaching the last row in which left colums are already filled. I need VBA code in order avoiding this manual double...
  6. marboa62

    Copy formulas down using autofill

    My routine works copying information on the left side of the sheet incresing month after month. On the right side I need only copy the formulas in the last row in the row following, up to the total COLUMS A B ... Q R S ... Z ... ... ... ... ... ...
  7. marboa62

    VISUAL BASIC FOR APPLICATION (EXCEL) -- INSERT ROWS

    Great Glenn ! Thank you so much ! Hasta luego Marins I may be wrong but I have no doubt
  8. marboa62

    VISUAL BASIC FOR APPLICATION (EXCEL) -- INSERT ROWS

    Thanks Glenn, I promise non to use caps in the title in the future, I knew that but I didnt' give a format in the hurry So I can use Range ... My complete code is ... Range("B2").Select Selection.End(xlDown).Select For y = 1 To 100 Selection.EntireRow.Insert Next y ... You can see I need...
  9. marboa62

    VISUAL BASIC FOR APPLICATION (EXCEL) -- INSERT ROWS

    good morning America ! I have a little program in visual basic for application in Excel The code "Selection.EntireRow.Insert" allow to insert only one row in the sheet How can I insert 100 rows one-shot ? Thank you Marins

Part and Inventory Search

Back
Top