range - unable to get currentregion property of the Region Class VBA -

-

i'm getting error "unable currentregion property of region class" in below piece of code. can help? defects_dump global constant defined sheet name.

dim wbktool workbook dim llastrow long  set wbktool = thisworkbook wbktool.sheets(defects_dump)     .activate     llastrow = .range("a1").currentregion.rows.count     'more code after this... end


Comments

Post a Comment

Popular posts from this blog

python - Consider setting $PYTHONHOME to <prefix>[:<exec_prefix>] error -

-
Image
i getting same error when python manage.py runserver. there no such error when have ubuntu 15.10. got started when upgraded ubuntu 16.04. question might duplicate have tried solution provided question have applied command dpkg --configure -a, have done apt-get update,upgrade,dist-upgrade, clean, -f install. have reinstalled python2.7 , python3 no success though. here screenshot while trying run django application i got after re-installing python please me? bashrc file # ~/.bashrc: executed bash(1) non-login shells. # see /usr/share/doc/bash/examples/startup-files (in package bash-doc) # examples # if not running interactively, don't case $- in *i*) ;; *) return;; esac export pythonhome="/usr/bin/python" echo $virtualenvwrapper_python echo 'tushant' # don't put duplicate lines or lines starting space in history. # see bash(1) more options histcontrol=ignoreboth # append history file, don't overwrite shopt -s histappend # setting h...
Read more

javascript - Feed FileReader from server side files -

-
i´m starting customize/improve old audio editor project. can import audio tracks canvas via drag&drop computer. thing use audio tracks stored in server clicking on list of available tracks... instead of use <input type="file"> tags. how can read server side files filereader?ajax perhaps? in advance. this code file reader: player.prototype.loadfile = function(file, el) { //console.log(file); var reader = new filereader, filetypes = ['audio/mpeg', 'audio/mp3', 'audio/wave', 'audio/wav'], = this; if (filetypes.indexof(file.type) < 0) { throw('unsupported file format!'); } reader.onloadend = function(e) { if (e.target.readystate == filereader.done) { // done == 2 $('.progress').children().width('100%'); var onsuccess = function(audiobuffer) { $(el).trigger('audiee:fileloaded', [audiobuffer, file]); ...
Read more

php - yii multiselect dropdown with search property? -

-
i want searchable multiselect dropdown.i have seen yii multiselect , echmultiselect extension these not according need. please suggest ext or code this. suggestion appreciated. dropdown example - same stackoverflow uses tags input. you can use chosen plugin. available yii extension, called chosen widget example of usage: //1st step make list box proper selector <?php echo chtml::activelistbox($model, 'attribute', $data, array('class'=>'chosen', 'multiple'=>true, 'data-placeholder'=>'select')) ?> //2nd step use widget <?php $this->widget('ext.chosen.echosenwidget',array( 'selector'=>'.chosen', )); ?> it magic , convert normal multiple select searchable multiple select. of course there lot of options, described in chosen plugin documentation .
Read more