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

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/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

亲爱的 Coder【最近整理,可免费获取】👉 最新必读书单  | 👏 面试题下载  | 🌎 免费的AI知识星球