excel - Method range of object _global failed -


i want use value in c2 populate rest of column c same value way bottom of data in sheet.

sub testfill1() ' ' testfill1 macro '  '     sheets(1).select     lngendrow = lastcellblock      range("c2:c" & lngendrow).formular1c1 = "1" end sub 

i want use value in c2 populate rest of column c same value way bottom of data in sheet.

this should want:

sub filldown()     range("c2", "c" & rows.count).filldown end sub 

if doesnt work or doesnt answer question let me know


Comments

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -