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

Popular posts from this blog

tcpdump - How to check if server received packet (acknowledged) -