每个行值的Excel宏？ [英] Excel macros for each row value?

问题描述

Hello All，

我想知道excel宏，我已经使用excel宏记录了一组工作，如果我想对所有行做同样的事情，我该如何自动完成使用宏，请有人建议我解决它。

在此先感谢



我尝试过：



我已经记录了第一行程序，但我想对所有行值进行操作，任何人都可以告诉我解决它的最佳方法。

Hello All ,
I want to know excel macros , i have recorded a a set of work using excel macro and if i want to do the same thing for all rows , how can i do that automatically using macros, please anybody suggest me to solve it.
Thanks in Advance

What I have tried:

I have recorded the first row procedure , but i want to do for the all row values , can anybody tell me best way to solve it.

推荐答案

解决方案取决于您在每一行上执行的操作，启动位置，停止位置，一些约束以及Excel WorkBook中的一些内容。

如果没有关于这些的详细信息，则无法给你实用的建议。

更新问题的详细信息和宏的副本将有所帮助。



否则，如果你想学习如何自己编写Excel宏：

自2000年以来Excel中嵌入的语言是VBA（Visual Basic for Applications）

如果你谷歌Excel宏vba，你将找到许多帮助网站和教程。

The solution depend on what you do on each row, where you start, where you stop, some constraints and a few things that are in your Excel WorkBook.
Without details about these, it is impossible to give you practical advice.
Updating the question with details and a copy of your macro will help.

Otherwise, if you want to learn how to program an Excel macro by yourself:
The language embedded in Excel since 2000 is VBA (Visual Basic for Applications)
If you Google "Excel macro vba", you will find many helping sites and tutorials.

这篇关于每个行值的Excel宏？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！