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, 2019
It 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