View original (French)

VBA Method range failed

Solved
Anonymous user -  
Hello,
I am currently programming in VBA Excel

I have a counter j that needs to provide me with a row number.

I want to merge cells, so I need to select the cells to merge and apply the formula, but I don’t understand why it says that my Range method has failed; it seems correct to me...
Could you enlighten me on the issue 

Workbooks("etude delai.xls").Sheets("Feuil1").Range("A" & j & " : H" & j).Select


--
95% of errors come from what’s between the keyboard and the chair

Remember to check "resolved" if applicable
Configuration: Windows XP Opera 9.25

8 answers

  1. Kiddy
    Range("C10:D20").Select
    Selection.Copy
    Sheets("Feuil2").Select
    Range("B7").Select
    ActiveSheet.Paste

    Do not confuse selected sheet with active sheet...

    Either you write:

    Range("C10:D20").Select
    Selection.Copy
    Sheets("Feuil2").Select
    Range("B7").Select
    Selection.Paste

    Or:

    Range("C10:D20").Select
    Selection.Copy
    Sheets("Feuil2").Activate
    Range("B7").Activate
    ActiveCell.Paste
    4
    1. cythonas
      ("A" & j & " : H" & j).Select tries to set its (you never know^^)
      ("A" & j & : "H" & j).Select
      1
      1. Anonymous user
        A" & j & ": "H" & j).Select cannot work because the method is
        range("col1row1: col2row2).select
        for example

        range("A1:H1").select

        --
        95% of errors come from what is between the keyboard and the chair

        Remember to check "resolved" if applicable
        1
        1. cythonas
          Yes, I'm familiar with the "theoretical" structure of the range!
          But in practice, VB lets certain things slip through..
          In fact, it's the '&' behind the 'j' that bothers me. Why did you put one there??
          0
          2. Anonymous user
            No, it's fine, I found it, it's a damn &$*chr&acter that was too much
            --
            95% of the errors come from what is between the keyboard and the chair

            Remember to check "resolved" if applicable
            0
            1. frrodg
              Hi
              try a bit to put Activate in place of Select
              0
              1. Anonymous user
                It's all good, I found it, thank you. It was a stupid space that messed everything up and I was also missing a Windows("etude delai.xls").Activate higher up. Thanks to both of you for your help.
                --
                95% of errors come from what is between the keyboard and the chair.

                Please remember to check "resolved" if applicable.
                0
                1. joey6
                  Hi everyone,
                  I'm starting to do some VBA/Excel programming, and I have a problem that I really can't solve.
                  I'm encountering the infamous "VBA Method Range failed" problem while creating a macro in Excel, and then I take the code generated by the macro into a procedure.
                  The generated code is as follows:

                  Range("C10:D20").Select
                  Selection.Copy
                  Sheets("Sheet2").Select
                  Range("B7").Select
                  ActiveSheet.Paste

                  After doing some research, I realized that the sheet change is what causes the problem because if I do the copy-paste on the same sheet, there are no issues.

                  Has anyone ever had this problem?
                  Thanks in advance
                  Joey6
                  2