VBA编程中常用过程代码

VBA编程常用过程代码方案，供大家写代码参考，陆续发表：

VBA过程代码6：返回当前单元格的位移

Sub MyNZ()

on error resume next

ActiveCell.Offset(0, 1).Select '当前单元格向左移动一格

ActiveCell.Offset(0, -1).Select '当前单元格向右移动一格

ActiveCell.Offset(1 , 0).Select '当前单元格向下移动一格

ActiveCell.Offset(-1 , 0).Select '当前单元格向上移动一格

end sub

代码的解析及说明：上述代码过程将将产生当前活动单元格的移动，on error resume next 是为了避免上述程序产生错误，因为有时单元格是不能移动的，为了解除上述错误，加错误处理代码。

VBA过程代码7：给当前或某个单元格赋值

Sub MyNZ()

ActiveCell.Value = “你好！！！” ’给活动单元格赋值

Range(“a1”).value=“hello” ’给指定单元格a1赋值

sheets(“sheet2”).select

range(“a1”).value=“hello” ’给sheet2的Ａ１单元格中插入" hello "

Sheets(“sheet1”).Range(“a1”).Value = “hello” ’给sheet2的Ａ１单元格中插入" hello "

End sub

代码的解析及说明：上述代码第一行是给活动的单元格赋值；第二行是给活动的工作表的A1单元格赋值；第三四行先将sheet2选中，然后在将“HELLO"赋到A1单元格中；第5行sheet2不必被选中，即可“HELLO"赋到sheet2 的A1单元格中。

VBA过程代码8：隐藏及显示工作表

Sub MyNZ()

sheets(“sheet1”).Visible=False '隐藏SHEET1这张工作表

sheets(“sheet1”).Visible=True '显示SHEET1这张工作表

End sub

代码的解析及说明：上述代码过程第一行利用了对象的Visible属性为False隐藏工作表；第二行利用对象的Visible属性为True显示工作表

VBA过程代码9：对于工作表遍历打印预览

Sub MyNZ()

Dim myEX As Worksheet

For Each myEX In Worksheets

myEX.PrintPreview

Next myEX

End sub

代码的解析说明：有时候我们想把所有的EXCEL中的SHEET都打印预览，请使用该段代码，它将在你现有的工作簿中循环，直到最后一个工作簿结束循环预览。这里的for each next 是一个遍历的循环，在工作表集合中遍历，myEX是一个工作表对象，是集合中的元素。PrintPreview是预览打印。

VBA过程代码10：得到当前单元格的地址

Sub MyNZ()

msgbox ActiveCell.Address

End sub

代码的解析说明：上述代码过程将返回当前活动单元格的地址，这个地址是绝对地址，也就是说是前面有$符号的地址，关于这个Address函数的详细说明及提取地址的使用在我的VBA解决方案中丛书中有非常详细的案例使用。

留言板：面向初学朋友的视频正在录制中，已经完成约三分之一。这套视频是以《VBA代码解决方案》为蓝本的视频讲解，让初学者更易学习，看视频可以了解到更多VBA的知识，以及代码的写法，程序的调试等等,现在推出“每天20分钟，半年精进VBA的活动”。

https://www.yy.com/search-76624520?

https://www.yy.com/search-76624520?

https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC?

https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%b8%bd%e9%83%bd%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%85%a4%e7%82%ad%e6%80%bb%e5%8c%bb%e9%99%a2%e5%8c%bb%e5%ad%a6%e7%be%8e%e5%ae%b9%e6%95%b4%e5%bd%a2%e4%b8%ad%e5%bf%8376624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%8d%8e%e9%9f%a9%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%8d%97%e5%8a%a0%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%89%ba%e6%98%9f%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%ba%ac%e6%b0%91%e5%8c%bb%e9%99%a2%ef%bc%88%e5%8e%9f%e9%92%93%e9%b1%bc%e5%8f%b0%e5%8c%bb%e9%99%a2%ef%bc%89%e6%95%b4%e5%bd%a2%e5%a4%96%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%a3%b9%e5%8a%a0%e5%a3%b9%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%8a%a0%e5%87%8f%e7%be%8e%e6%95%b4%e5%bd%a2%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%a6%be%e5%8a%9b%e5%ba%b7%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%89%be%e7%8e%9b%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%9f%a9%e5%95%b8%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%b8%9c%e6%96%b9%e7%91%9e%e4%b8%bd%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%a6%be%e7%be%8e%e5%98%89%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%b8%9c%e6%96%b9%e5%92%8c%e8%b0%90%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%ba%9a%e9%a6%a8%e7%be%8e%e8%8e%b1%e5%9d%9e%e6%95%b4%e5%bd%a2%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%ba%9a%e9%a6%a8%e7%be%8e%e8%8e%b1%e5%9d%9e%e6%95%b4%e5%bd%a2%e5%8c%bb%e9%99%a2%e7%96%a4%e7%97%95%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%b6%a6%e7%be%8e%e7%8e%89%e4%b9%8b%e5%85%89%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%8d%97%e5%8a%a0%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e6%a4%8d%e5%8f%91%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%ba%ac%e5%9f%8e%e7%9a%ae%e8%82%a4%e7%97%85%e5%8c%bb%e9%99%a2%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e4%b8%ad%e5%bf%8376624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%9b%85%e9%9d%93%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%a2%a7%e8%8e%b2%e7%9b%9b%e6%a4%8d%e5%8f%91%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%b1%b3%e6%89%ac%e4%b8%bd%e6%a0%bc%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%a4%a9%e8%b5%90%e4%b8%bd%e4%ba%ba%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%b8%89%e4%bb%81%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%be%8e%e8%8e%b1%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%94%bb%e7%be%8e%e5%8c%bb%e9%99%a2%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e7%a7%91%ef%bc%88%e5%8e%9f%e9%95%bf%e8%99%b9%e5%8c%bb%e9%99%a2%ef%bc%8976624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%b2%83%e5%b0%94%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%96%af%e8%bf%88%e5%b0%94%e9%bd%bf%e7%a7%91%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%b8%b8%e5%a5%bd%e4%b8%bd%e6%a0%bc%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%96%af%e5%87%af%e4%b8%bd%e9%9b%85%e5%9b%bd%e9%99%85%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%81%9a%e7%be%8e%e4%bb%95%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%a7%91%e5%8f%91%e6%ba%90%e6%a4%8d%e5%8f%91%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%89%be%e7%be%8e%e4%b8%bd%e6%95%b4%e5%bd%a2%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%b0%8f%e5%bf%a0%e4%b8%bd%e6%a0%bc%e5%8c%bb%e7%96%97%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%82%a6%e8%8a%b3%e4%ba%9a%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%88%b1%e5%bd%bc%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%ab%8b%e5%a5%a5%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%9b%8d%e7%a6%be%e6%a4%8d%e5%8f%91%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%ba%9a%e5%a5%87%e9%be%99%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%ac%a7%e6%89%ac%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%86%9b%e5%8c%ba%e6%80%bb%e5%8c%bb%e9%99%a2%e6%bf%80%e5%85%89%e6%95%b4%e5%bd%a2%e4%b8%ad%e5%bf%8376624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%93%9d%e6%b5%b7%e4%b8%ad%e5%8c%bb%e5%8c%bb%e9%99%a2%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%9d%8e%e6%b2%81%e5%a5%95%e5%8d%8e%e6%84%8f%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-%e4%b8%9c%e6%96%b9%e7%bb%b4%e7%ba%b3%e6%96%af76624520%E5%8C%97%E4%BA%AC%e7%88%b1%e6%80%9d%e5%be%97%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%b8%9c%e5%8d%97%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%bd%93%e4%bb%a3%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%96%87%e7%90%b3%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%9b%8a%e8%b5%9b%e5%b0%94%e5%8f%a3%e8%85%94%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%be%af%e6%b6%9b%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%9b%99%e5%85%89%e5%8c%bb%e9%99%a2%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%83%a0%e6%ac%a3%e4%ba%ac%e5%b7%9e%e5%8f%a3%e8%85%94%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%a6%96%e7%8e%ba%e4%b8%bd%e6%a0%bc%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%bc%8a%e7%be%8e%e5%b0%94%e9%95%bf%e5%b2%9b%e5%8c%bb%e5%ad%a6%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%b8%82%e5%92%8c%e5%b9%b3%e9%87%8c%e5%8c%bb%e9%99%a2%e6%95%b4%e5%bd%a2%e5%a4%96%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%9c%9c%e9%82%a6%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%b8%82%e6%9c%9d%e9%98%b3%e5%8c%ba%e5%8f%8c%e6%a1%a5%e5%8c%bb%e9%99%a2%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%9f%a9%e8%aa%89%e5%9b%bd%e9%83%bd%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%b8%96%e5%8d%9a%e4%ba%ac%e9%83%a1%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%be%8e%e4%bc%8a%e5%9b%bd%e9%99%85%e6%95%b4%e5%bd%a2%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%b8%82%e7%ac%ac%e5%85%ad%e5%8c%bb%e9%99%a2%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e5%a4%96%e7%a7%9176624520
https://www.yy.com/search-%e4%b8%ad%e5%9b%bd%e5%8c%bb%e5%ad%a6%e7%a7%91%e5%ad%a6%e9%99%a2%e6%95%b4%e5%bd%a2%e5%a4%96%e7%a7%91%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%92%8c%e8%b0%90%e7%be%8e%e4%b8%bd%e6%b1%87%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%bc%8a%e7%be%8e%e5%b0%94%e7%be%8e%e5%ae%b9%e5%81%a5%e7%bf%94%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%a1%82%e8%8e%b9%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%8d%8e%e5%8e%a6%e6%b0%91%e4%bc%97%e7%9c%bc%e7%a7%91%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%86%a0%e7%be%8e%e5%8f%a3%e8%85%94%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%86%99%e4%bb%81%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%ab%98%e5%85%b0%e5%be%b7%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%ACAJ%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%ab%98%e6%96%b0%e6%a4%8d%e5%8f%91%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%ba%ac%e5%85%b8%e4%b8%bd%e5%9b%ad%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%be%b7%e7%be%8e%e8%af%8a%e8%81%94%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%a9%ba%e5%86%9b%e8%88%aa%e7%a9%ba%e5%8c%bb%e5%ad%a6%e7%a0%94%e7%a9%b6%e6%89%80466%e5%8c%bb%e9%99%a2%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e4%b8%ad%e5%bf%8376624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%97%b6%e7%8f%8d%e5%a0%82%e5%8c%bb%e9%99%a2%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e7%a7%9176624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%87%bb%e7%91%9e%e5%a5%a5%e7%be%8e%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%9c%a3%e8%b4%9d%e5%8f%a3%e8%85%94%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%ac%a7%e5%8d%8e%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%b0%9a%e7%be%8e%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e8%87%bb%e7%91%9e%e7%be%8e%e6%80%9d%e7%ab%a5%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e4%ba%9a%e5%b3%b0%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%91%9e%e4%b8%bd%e6%96%af%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e7%bb%b4%e5%b0%94%e5%8f%a3%e8%85%94%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%b0%b8%e5%81%a5%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%82%a6%e7%84%b6%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-%e5%85%ab%e5%a4%a7%e5%a4%84%e6%95%b4%e5%bd%a2%e5%8c%bb%e9%99%a2%e5%9b%bd%e8%b4%b8%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%8f%af%e6%80%9d%e7%be%8e%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e8%af%8a%e6%89%8076624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e5%b2%a9%e4%b9%8b%e7%95%94%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae%b9%e9%97%a8%e8%af%8a%e9%83%a876624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e9%87%91%e8%8e%8e%e6%95%b4%e5%bd%a2%e7%be%8e%e5%ae%b9%e5%8c%bb%e9%99%a276624520
https://www.yy.com/search-76624520%E5%8C%97%E4%BA%AC%e6%b1%87%e7%be%8e%e4%b8%bd%e5%8c%bb%e7%96%97%e7%be%8e%e5%ae