excel - VBA - Insert rows below a dynamic header -
i looking insert new row below frozen header row @ top of spreadsheet. issue face amount of rows in header ever changing want row inserted @ first line below header. there flag in row says frozen? count amount of rows said flag, add 1 , insert row. helpful.
matt
here are!
sub insertrowbelowheader() rows(activewindow.splitrow + 1).insert end sub
Comments
Post a Comment