See below to know what code is new and where it inserts in the existing
sub...
<existing lines
If Not wks Is wksTarget Then
lLastRow = wks.Cells(wks.Rows.Count, "K").End(xlUp).Row
<insert 1 line here
iPos = 1 '//initialize RowHeight trigger
<existing lines
For Each rng In wks.Range("K2:K" & lLastRow)
If Not rng.Value = 1 Then
lNextRow = lNextRow + 1
With wksTarget
<insert 3 lines here
'Set RowHeight for the 1st row of each wks data.
'then reset the trigger to skip subsequent rows.
If iPos 0 Then .Rows(lNextRow).RowHeight = 24: iPos
= 0
...where the entire snippet was intended to replace existing 6 lines via
copy/paste because those existing lines are within the snippet.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion