Excel 两列单元格合并超级链接的VBA 写法

Python114

Excel 单元格 分两列 (B列存放姓名, C列存放链接)

列如:

姓名学号博客地址 1309032022 小张

1413042001 小张学Python

1413042002 小张学Python

<span class="hljs-keyword">Public <span class="hljs-keyword">Sub addURL()

 <span class="hljs-keyword">Dim BLeft <span class="hljs-keyword">As <span class="hljs-built_in">String
 <span class="hljs-keyword">Dim CRight <span class="hljs-keyword">As <span class="hljs-built_in">String
 <span class="hljs-keyword">Dim Line <span class="hljs-keyword">As <span class="hljs-built_in">Integer

 <span class="hljs-keyword">For Line = <span class="hljs-number">2 <span class="hljs-keyword">To <span class="hljs-number">58               </span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
输入验证码查看隐藏内容

扫描二维码关注本站微信公众号 Johngo学长
或者在微信里搜索 Johngo学长
回复 svip 获取验证码
wechat Johngo学长