excel cannot complete this task with available resources -

-

when i'm trying copy data in 1 of worksheets new sheet using below code in excel 2007, windows 7, i'm facing error "excel cannot complete task available resources. choose less data or close other applications".

when close other applications, showing same message. how resolve issue? please advise.

with activesheet      .range("a1").select      .usedrange.specialcells(xlcelltypevisible).copy  end  thisworkbook     set ws = .worksheets.add(after:=.sheets(.sheets.count))     newsheet = activesheet.name end   activesheet     .range("a1").select      selection.pastespecial paste:=xlpastecolumnwidths     selection.pastespecial xlpasteall     .range("a1").select  end

when save xls .xls (97-2003) working fine. want run more data 65k

i tested code on newly created excel document , copied 80k rows new sheet. code works...

i did create macro sub routine , run multiple times check.

but said saved document once xls. maybe got limitations also.

please , create new excel document , save xlsx...


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more