宏根据excel中的表格范围将公式复制并粘贴到空白单元格中??? [英] Macro to copy and paste formula into blank cells based on table range in excel???

问题描述

我正在试图找出一个将从一个单元格复制公式的宏根据表的长度将其粘贴到下面行中的空白单元格中。每次运行数据查询时，表大小都会更改。我想我可以命名范围，但我必须将最后一行基于另一个包含数据的列。这就是我没有用的。

I am trying to figure out a macro that will copy a formula from one cell and paste it into blank cells in the rows below based on the length of the table.  The table size changes each time I run the data query.  I was thinking that I could name the range but I have to base the last row on another column that has data in it.  This is what I had that doesn't work.

Code Snippet

推荐答案

您好，

试试这个，

Hi,

Try this,

代码段

这篇关于宏根据excel中的表格范围将公式复制并粘贴到空白单元格中???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！