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

database - How many Observations in SAS Sample Data Output -

-
i have sample sas output , need find out how many observations , compute t-statistic beta1. can me started on how go doing this? sample sas output to number of obs in dataset can run code. data _null_; put nobs=; stop; set sashelp.class nobs=nobs; run; a proc reg give summary statistics need, namely, t-value, beta1 , beta null, intercepts of regression equation. here simple easy follow example http://support.sas.com/documentation/cdl/en/statug/63962/html/default/viewer.htm#statug_reg_sect003.htm
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

emulation - Android map show my location didn't work -

-
i have been struggle current location in google map, tried official map demo, not working also. shows getmylocation button on upper right, didn't show blue dot on map current location. here code , i'm using emulator target api 23, guess may emulator's problem since code download directly github. advice appreciated. [screenshot][1] package com.example.mapdemo; import com.google.android.gms.maps.googlemap; import com.google.android.gms.maps.googlemap.onmylocationbuttonclicklistener; import com.google.android.gms.maps.onmapreadycallback; import com.google.android.gms.maps.supportmapfragment; import android.manifest; import android.content.pm.packagemanager; import android.os.bundle; import android.support.annotation.nonnull; import android.support.v4.app.activitycompat; import android.support.v4.content.contextcompat; import android.support.v7.app.appcompatactivity; import android.widget.toast; /** * demo ...
Read more