作者:轩风羽_609 | 来源:互联网 | 2023-07-20 17:41
iamanovicewhenitcomestoVBAandwouldlikesomehelp.我是VBA的新手,想要一些帮助。Iamtryingtocopyo
i am a novice when it comes to VBA and would like some help.
我是VBA的新手,想要一些帮助。
I am trying to copy one cell at a time from one sheet to to another. The reason for this is because I want to copy one cell (account #) from a list (sheet "List") and paste into a predefined cell is another sheet ("Analysis") and run code that will extract data from a program. i want to then repeat this process for all the account #s in that list until the list ends. The # of accounts in this list will change periodically. Account # will always be entered into Cell "F2"
我试图将一个单元格从一张纸复制到另一张纸。这是因为我想从列表中复制一个单元格(帐户#)(表单“List”)并粘贴到预定义单元格中是另一个工作表(“分析”)并运行将从程序中提取数据的代码。我想对该列表中的所有帐户#s重复此过程,直到列表结束。此列表中的帐户数量将定期更改。帐号#将始终输入单元格“F2”
The code i am using to extract data is,
我用来提取数据的代码是,
Range("F2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.Run "'Option holding.xls'!SecurityDistribution"
![enter image description here](https://www.#.com/go/aHR0cHM6Ly9pLnN0YWNrLmltZ3VyLmNvbS8xc0gzei5wbmc=)
1 个解决方案