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>
姓名学号博客地址 1309032022
1413042001
1413042002
Original: https://www.cnblogs.com/xiaozhangpython/p/12844339.html
Author: 小张学Python
Title: Excel 两列单元格合并超级链接的VBA 写法
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/563685/
转载文章受原作者版权保护。转载请注明原作者出处!