Forum Discussion
PMHunt1955
Jun 29, 2019Brass Contributor
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.     ...
- Jun 29, 2019It turned out that the statement needed some extra quotes as per following - Worksheets(wswkname).Rows(fxRI1 & ":" & fxRI2).Insert Shift:=xlShiftDown 
PMHunt1955
Jun 29, 2019Brass Contributor
It turned out that the statement needed some extra quotes as per following -
Worksheets(wswkname).Rows(fxRI1 & ":" & fxRI2).Insert Shift:=xlShiftDown