Hi
I need code to print specific range without empty row based on selected sheet name from combobox on userform .
the range will be A1: H2000 but the real range is filled A1:H12 based on what I need increase rows or decrease as long I need it . so should ignore empty rows
there are empty rows contains borders should also ignore it when print out .
if there are empty rows between filled rows should not delete when print out it just after lastrow is filled .
thanks
I need code to print specific range without empty row based on selected sheet name from combobox on userform .
the range will be A1: H2000 but the real range is filled A1:H12 based on what I need increase rows or decrease as long I need it . so should ignore empty rows
there are empty rows contains borders should also ignore it when print out .
if there are empty rows between filled rows should not delete when print out it just after lastrow is filled .
thanks