VBA code of batch copy hyperlink address
来源:互联网 发布:linux安装make工具 编辑:程序博客网 时间:2024/06/06 14:29
Sub AddHyperlink()
Application.ScreenUpdating = False
With ActiveSheet
lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = 1 To lastrow
Cells(i, 2) = Cells(i, 1).Hyperlinks(1).Address
Next i
End With
Application.ScreenUpdating = True
End Sub
Application.ScreenUpdating = False
With ActiveSheet
lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = 1 To lastrow
Cells(i, 2) = Cells(i, 1).Hyperlinks(1).Address
Next i
End With
Application.ScreenUpdating = True
End Sub
0 0
- VBA code of batch copy hyperlink address
- VBA code from template is linked to doc file. I need a copy
- AntiPattern: Batch Code Review
- List of HTTP status code & FTP status code copy from Wiki
- Hyperlink
- HYPERLINK
- HyperLink
- CODE 128 VBA
- VBA Code Samples
- Building VBA Code(转)
- Overview of Batch Management
- How can I get the IPv4 address of an interface in linux from C code ?
- Excel: How to run C# code behind with a click of a button on a Worksheet, without VBA code
- Several address of statistics
- The address of IP
- Address Of A Gif
- fast memory copy code
- deep copy code
- WAMPServer介绍
- struts2开发一般流程
- 我的c++之路----匆匆而过的11月
- Vim 简介以及常用命令
- 主流移动应用开发框架(2)——fragment+fragmenttabhost实现底部选项卡导航(可滑动切换)
- VBA code of batch copy hyperlink address
- 第14周项目2.2 按同学姓名排序的成绩名单
- VS2010 MFC解决方案 工程更名工具 20150923_1500更新v1.3
- Nginx的学习资料
- C/C++中extern关键字详解
- C++ primer (第五版)课后题答案(九)
- 折腾二维数组
- android Content Provider 详解
- 到底做了些什么