在excel宏工作表中查找最后一行 [英] Find last row in excel macro worksheet

问题描述

我有windows表单应用程序。它有一个跟踪时间和活动的datagridview。

我必须将每个新行保存到excel文件并格式化并运行宏。

我试过找到工作表的最后一行，我必须复制我的新行字符串。

但是当我在范围内运行查找时，它会抛出10015行。

可能是因为宏预填充了某些行？如果是这样我怎么能找到它们之间的最后一行？

非常感谢任何帮助！

I have windows form application. It has a datagridview in it that tracks time and activity.
I have to save every new row into and excel file that is formatted and runs a macro.
I have tried to locate the last row of the sheet where i have to "copy" my new rows string.
But when i run the find in the range it throws row 10015.
Could it be because of the macro prepopulates certain rows? If so how can i find the last used row between those?
Any help is greatly appreciated!

推荐答案

这篇关于在excel宏工作表中查找最后一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！