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

Popular posts from this blog

javascript - How to get current YouTube IDs via iMacros? -

c# - Maintaining a program folder in program files out of date? -

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