Forum Discussion

PMHunt1955's avatar
PMHunt1955
Brass Contributor
Jun 29, 2019
Solved

Correct formatting of Row parametr within a Worksheets Insert command

Just to show that I have set up wswkname correctly -   Early in the sub the following code lines execute, in the 'initialisation' part of the sub, and the values work elsewhere perfectly well.   ...
  • PMHunt1955's avatar
    Jun 29, 2019

    PMHunt1955 

     

    It turned out that the statement needed some extra quotes as per following -

     

    Worksheets(wswkname).Rows(fxRI1 & ":" & fxRI2).Insert Shift:=xlShiftDown

     

     

Resources