Excel VBA Run time error 450: Selection.Style = "Comma" -
i have received error 450 line of coding of selection.style="comma"
, don't know what's going on. can teach me how fix it? possibly using older version of excel?
range("e65536").end(xlup).offset(1, 0).select activecell.formula = "=sum(e2:e" & activecell.row - 1 & ")" activecell.copy range(activecell, activecell.offset(0, 2)).select ' <---------selecting e50:g50 selection.pastespecial paste:=xlpasteformulas, operation:=xlnone, >skipblanks:=false, transpose:=false selection.borders(xledgetop) ' borders sum results .linestyle = xlcontinuous .colorindex = xlautomatic .tintandshade = 0 .weight = xlthin` end selection.borders(xledgebottom) .linestyle = xldouble .colorindex = xlautomatic .tintandshade = 0` .weight = xlthick` end selection.style = "comma" ' <--------------------error occur in line selection.numberformat = "_(* #,##0_);_(* (#,##0);_(* ""-""??_);_(@_)"`
Comments
Post a Comment