Excel VBA - Clear Column contents from row 2 down -
i trying clear column contents row 2 down on vba script running, piece of code below how going this.
this doesn't appear working, no syntax issues or error messages. there issues code?
option compare text option explicit sub loader() dim wb3 workbook set wb3 = thisworkbook wb3.worksheets("config sheet").range("f2").end(xldown).clearcontents end sub
try expanding range more single cell.
with wb3.worksheets("config sheet") .range("f2:f" & .range("f2").end(xldown).row).clearcontents end
if go config sheet worksheet, select f2 , tap ctrl+↓, have last cell selected. above modification same if had tapped ctrl+shift+↓.
Comments
Post a Comment