excel vba - Select rows which have a numeric value in the first cell (Column A) -

-

i using excel vba try , select range of rows on spread sheet located below last row numeric value in column a. row 40 need select from, location change. how perform selection based on non numeric value. selecting range of rows , deleting them using following 

rows("40:40").select range(selection, selection.end(xldown)).select application.cutcopymode = false selection.delete shift:=xlup 

dim lastrow integer  lastrow = activesheet.usedrange.rows.count      row = 2 lastrow     if not isnumeric(cells(row, 1))         row = row+1         rows(row).select         range(selection, selection.end(xldown)).select         application.cutcopymode = false         selection.delete shift:=xlup     end if next row

Comments

Post a Comment

Popular posts from this blog

javascript - How to diff two immutable objects -

-
is there way diff objects in immutable ? example: let = immutable.fromjs({ a: 10 }); let b = immutable.fromjs({ b: 10 }); let d = immutable.diff(a, b); // { a: 10 } console.log(d.tojs()); this useful when testing see how objects differ. it doesn't have show what's added/removed explicitly. want see properties a differs b can make them equal again. for example this: console.log(a.tojs()); console.log(b.tojs()); and check logs see differs b. in other thought might show both added , removed properties in same output. main point see not equal. so be: // { a: 10, b: 10 } console.log(d.tojs()); or maybe: // { added: { a: 10 }, removed: { b: 10 } } // console.log(d.tojs());
Read more

c# - How can I have the VS Debugger break in the correct location for exceptions thrown in Async methods in a Console App? -

-
i'm writing console app uses lots of async methods; i've made async main method can await in: static void main(string[] args) { mainasync(args).wait(); } static async task mainasync(string[] args) { // can use await here } however, when exception occurs; debugger break me on .wait() call. not experience. is there can debugger breaks exception occurs rather here? i'm using vs2015 , targeting .net 4.6 if influences answer.
Read more

javascript - React.js: onClick function from child to parent -

-
i used this article example (react way), not working me. please point me mistake, can't understand what's wrong. this error see: uncaught typeerror: this.props.onclick not function here code: // parent var senddocmodal = react.createclass({ getinitialstate: function() { return {taglist: []}; }, render: function() { return ( <div> { this.state.taglist.map(function(item) { return ( <tagitem nameprop={item.name} idprop={item.id} onclick={this.handleremove}/> ) }) } </div> ) }, handleremove: function(c) { console.log('on remove = ', c); } }); // child var tagitem = react.createclass({ render: function() { return ( <span classname="react-tagsinput-tag"> <span>{this.props.nameprop}</span> <a classname='react-tagsinput-remove' onclick={this.handleremove}></a...
Read more