VBA for overlaying a smaller table Drop Down list -

-

here following vba , works ok: - have couple of tables , used named ranges each of them. - then, on different tab (where code is) have 2 drop down lists users of excel report can select table (only 1 @ time) want display data for.

the problem me if select table drop down has 30 rows looks fine - table destination cell a2. if select table has 10 rows, new table 10 rows overlaid on previous 30 row table 20 rows(remaining 30 row table) under 10 row table still there.

my question is: how should change code below 20 rows previous table not appear when 10 rwo table selected drop down list?

let me know if above doesn't make sense..thanks v much.

my code @ minute follows:

private sub worksheet_change(byval target range)     dim tablename string     dim tablerange range     dim typeofcosts string     application.enableevents = false      if range("b1").text = "fixed staff costs"         typeofcosts = "_fixed_staff"     elseif range("b1") = "variable staff costs"         typeofcosts = "_variable_staff"     elseif range("b1") = "production costs"         typeofcosts = "_production"     elseif range("b1") = "infrastructure costs"         typeofcosts = "_infrastructure"     elseif range("b1") = "other costs"         typeofcosts = "_other"     else         typeofcosts = ""     end if      tablename = range("a1").text & typeofcosts & "_costs"      on error resume next     set tablerange = application.range(tablename)     debug.print thisworkbook.names.count         if not (tablerange nothing) , err = 0         tablerange.copy destination:=range("a3")     else         err.clear     end if     on error goto 0     application.enableevents = true end sub

this pretty blunt approach, without knowing more setup:

with range("a3").resize(1000,10)     .clearcontents     .clearformats end

Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more