excel - How to get the newly inserted worksheet -


so have pivottable , in column c there field showing details each record using this

for i=7 10    data.range("c" & i).showdetail = true    set wn = thisworkbook.worksheets(1) next

now works fine problem set wn = thisworkbook.worksheets(1) assigns wn first worksheet data.range("c" & i).showdetail = true inserts new worksheet has details @ 1st or 2nd position. want know new worksheet inserted , assign wn it.

do have make array or list keeps record of existing worksheets , check new 1 everytime? or there easy way determine newest worksheet in workbook irrespective of position.

look @ activesheet. showdetail creates new sheet , activates - set wn=activesheet should work. 

sub test()      dim c range     dim wrksht worksheet     thisworkbook.worksheets("sheet2").pivottables(1)         each c in .databodyrange.resize(, 1)             c.showdetail = true             set wrksht = activesheet             debug.print wrksht.name         next c     end  end sub

this link jon peltiers page on pivot tables should massive help... https://peltiertech.com/referencing-pivot-table-ranges-in-vba/


Comments

Post a Comment

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

while performing simple hover test on firefox through selenium (3.4.0) python bindings (3.4.3) using of available os in saucelabs (except linux, latest available firefox version old), performing following actionchain: hover = actionchains(driver) hover.move_to_element(elm_men_menu).perform() it throws following error: taceback: file [...] in testhover hover.perform() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 80, in perform action() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 290, in <lambda> command.move_to, {'element': to_element.id})) file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/remote/webdriver.py", line 256, in execute self.error_handler.check_response(response) file "/usr/local/lib/python2.7/...
Read more

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

Ruby Google Calendar Integration Watch Event / Push Notification -

the following snippet of code print events calendar id, calendar configured , try set watch notification on calendar. everything works the watch event method. i'm getting error: apis/core/http_command.rb:212:in `check_status': unauthorized (google::apis::authorizationerror) thi seems strange since calendars , events retrieve working fine. service = google::apis::calendarv3::calendarservice.new service.client_options.application_name = application_name service.authorization = authorize # fetch next 10 events user calendar_id = 'us7i4kt2to4mpb0b5et1f9f4co@group.calendar.google.com' response = service.list_events(calendar_id, max_results: 10, single_events: true, order_by: 'starttime', time_min: time.now.iso8601) puts "upcoming events:" puts "no upcoming events found" if response.items.empty? response.items.e...
Read more