这种情况下，我是否有可能通过do untill的方式让报错语句自动循环执行直到不再报错？untill的条件应该怎么写？
-
等级
本版专家分：0结帖率 45.45% -
想请教一下各位大佬，VBA中我有遇到一个问题，有概率出现弹窗报错：类Range的copypicture方法无效，但这种情况通常点击调试之后点击继续即可正常运行
这种情况下，我是否有可能通过do untill的方式让报错语句自动循环执行直到不再报错？untill的条件应该怎么写？展开阅读全文
-
等级
本版专家分：0
-
报错的语句是：
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
-
等级
本版专家分：6649勋章
-
- 签到新秀 累计签到获取，不积跬步，无以至千里，继续坚持！
-
-
红花
2020年2月 VB大版内专家分月排行榜第一
2019年7月 VB大版内专家分月排行榜第一
2019年5月 VB大版内专家分月排行榜第一
2019年3月 VB大版内专家分月排行榜第一
-
-
试试这样行不行:
on error resume next
do
err.clear
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
loop until err.number = 0
-
等级
本版专家分：0
-
看起来好使！谢谢老哥！！！
- VBA-Do Until 和 Do while
Sub doUtil() Dim num% 'until直到条件成立时，停止循环 ...Do Until num >3 num = num + 1 MsgBox num Loop End Sub ============================================ Sub doWhile() Dim num% 'un...
- python untill_【求助】关于telnetlib的方法read_until遇到的问题 - Python论坛 - 51CTO技术论坛_中国领先...
下面用userinfo保存了login以前的log，用pwdinfo保存了用户名到password的log，但是后面的print log却没有打印出用户名root，请大家帮忙看看是怎么回事？172.22.4.7这台机器系统是centos 6.4。...请大婶们指点小弟。...
- 聚类分析——聚类
聚类分析——聚类 定义：把数据对象划分成子集的过程，每个子集是一个簇，使得簇中的对象彼此相似，但与其他簇中对象彼此相异。 形成聚类的原则就是：使类内部的相似性最大，类间的相似性最小。...
- untill和till的区别
确实在很多场合可以交替使用，但是它们是有分别的。 ...英美国家的英语语法教师是这样来描述这两个字的分别的： “Till” is used to mean the time up to a particular instance and the action can continue...
- shell脚本编程循环之for/while/untill循环
循环执行： 将一段代码重复执行0、1或多次； 进入条件：条件满足时才进入循环； 退出条件：每个循环都应该有退出条件，以有机会退出循环； bash脚本： for循环 while循环 until循环 for循环： 两种格式...
- 情人节写给女朋友的小程序
今天是5情人节哈，再不解风情的人也得向女友表示表示。作为一个程序员，示爱的时候自然也要用我们自己的方式。这里给大家上传一段我在今年情人节的时候写给女朋友的一段简单的Java Swing代码，主要定义了一个对话框...
- 关于wait until snap is fully seeded等原因导致的ubuntu引导无限期黑屏问题
这个问题我找遍中外只有在一个老外的回复下看到过一点思路 黑屏的时候 立刻频繁切换f1 f2 f3控制台 直到f1 出现登陆界面 就可以了 当然 前提是你nomodeset 都弄过 攻克了这个汉比bug ...
- 编写三个shell程序，分别用for、while、untill求从1...100的素数和。
编写三个shell程序，分别用for、while、untill求从1…100的素数和。 来了老弟？ for: sum=0 for ((i=1; i<=100; i++)) do for ((j=2; j<i; j++)) do if((i%j==0)) then break fi done if((i==j))...
- Wont work again untill after editing gitolite-admin untill reboot
I go to <code>/tmp</code> and do a <code>git clone git:gitolite-admin. Then I modify the gitolite.conf file the way I want it (basically just removing stuff I no longer want). Then In commit and push...
- while&until循环详解
循环语句命令常用于执行一条指令或者一组指令，那么直到条件不在满足时停止，在shell脚本中循环语句常见有 while until for select循环语句。 在while循环语句主要用来重复执行一组命令或语句，在企业实际应用中...
- python untill_Python telnetlib read_until返回切断字符串
[Python telnetlib read_until recv problem]“read_until”函数返回带...我该怎么解决这个问题？请帮忙。在我的代码tn = telnetlib.Telnet(ip, 23, 5)prompt = ']# 'tn.write('echo "this is a long command for t...
- python untill_Python子流程.Popen（）对于Pygame，如何告诉Pygame wait-untill子进程是don...
我有一个大问题，太多的Pygame用户都有，我想从Pygame的用户那里获取输入。我可能在网上查过所有的信息，包括stackoverflow，什么也没解决。在所以我决定做一个解决方案，我创建了另一个Python脚本(我把它转换成.exe...
- Scraping stops working untill restart
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382) at org.eclipse.jetty.server.handler....
- RGB not updating untill reboot
<div><p>The RGB on my RAM (G.Skill Trident Z) and on my monitor (ASUS ROG STRIX XG248Q) does not update if I change it from razer synapse, but, if I restart my system it will go to what I put it as ...
- 【插件笔记】关于latex写algorithm算法的一点笔记
关于latex写algorithm的一点笔记algorithm2e包如果想在algorithm2e里用do-while而不是Repeat-Until如果想在overleaf里用中文 algorithm2e包 \usepackage[ruled]{algorithm2e} \begin{algorithm}[H] \caption{...
- Prevent form submission untill files finished uploading
<div><p>I've come across abit of an interesting unintended consequence of the images block (well the images_extended block, but the issues the same for both). <p>You can cause issues with your ...
- $meta().addApp not being applied untill mounted
<div><p>Hey , ... I noticed the <code>.addApp()</code> method is not getting applied untill the application is fully mounted, which causes flickering in the theme when first loading the app, see: ...
- Disable angelscript untill we actually use it again
<div><p>Since we aren't using angelscript for anything at the moment, I propose we disable or remove it, as it's only causing longer compile time and unneeded complexity.</p><p>该提问来源于...
- Command for delayed instructions untill passing a fix
<div><p>This involves giving an instruction that the pilot is expected to execute <em>AFTER</em> passing a specified position (whether a fix, a distance from a fix, etc). <p>"...
- Feature request: Continue work session untill user take action
<div><p>I usually do not like to break my flow and start a break time when work session. It usually takes few minutes but may also take longer sometimes. I propose adding following feature to give ...
- Disabling linkerd on 1.16 untill the addon is fixed
<div><p>该提问来源于开源项目：ubuntu/microk8s</p></div>
- leaderboard showing only the first player untill i refresh
<div><p>hi, as you can see in the screenshots, when i go to my leaderboard in the "all" section, i see only the first player. only when i refresh, the other players appears....
- Ignore calls to locationHashChanged untill page has finished loading
<div><p>Not sure if this is the most elegant fix. <p>When the user clicks the browser's 'Refresh' button $(document).ready()</code> will re-initialize everything. This includes a ...
- ABORT hangs untill timeout for netopeer subscription modules
<div><p>Hi, <p>We have some configuration management RPCs which are used for fetching remote netconf configuration files and apply that to sysrepo. <p>Configuration like: - There are some changes in ...
- Videos generated are not playing second time in FireFox untill refresh
<p>Videos generated are not playing second time in FireFox untill refresh <h2>Steps to reproduce <p>Record a video and save in some path, now in added the src for video tag and tried to play the video...
- How to disable body untill whole requests are completed.
<div><p>I am using this module and it great.... I want to show a div with some transparency to feel the user like really something is going on and they should have wait for a while. <p>Please help....
- completion results are not coming proper untill didChange message sent
<div><p>I am using this csharp language server with Monaco language client. Found that csharp language server is not returning proper completion result. It seems like the language server does not ...
- Server will not connect untill lint errors are solved.
<div><p>fixes #690 . -jain Please review the PR.</p><p>该提问来源于开源项目：Cloud-CV/EvalAI</p></div>
- Supervisor memory usage keeps growing untill Home Assistant server crashes
<div><p><strong>Home Assistant release with the issue: Home Assistant 0.112.4 <p><strong>Operating environment (HassOS/Generic): arch | x86_64 chassis | desktop dev | false docker | true ...
- Claymore-Dual-Miner：下载以太坊矿工（2020年更新）-源码
Claymore-Dual-Miner：下载以太坊矿工（2020年更新）