访问自动填充错误 [英] Access Autofill error

问题描述

我在计算机上运行脚本时收到错误，但同事可以毫无问题地运行它。 关于如何解决或我的问题可能是什么想法？

I'm receiving an error in a script when I run it on my computer, but a coworker is able to run it without issue.  Any ideas on how to resolve or what my issue may be?

Selection.AutoFill目的地：=范围（"L2：L"& r_wip）

Selection.AutoFill Destination:=Range("L2:L" & r_wip)

推荐答案

你好Russ，这看起来更像Excel问题而不是Access。您是否尝试从Access中自动化Excel？是"选择"您创建的Excel对象或您尝试使用的Excel方法/属性？如果是这样，那么你的同事可能会错过
参考。只是我的2美分......

Hi Russ, This looks more like an Excel question than Access. Are you trying to automate Excel from within Access? Is "Selection" an Excel object you created or an Excel method/property you're trying to use? If so, it might be you're missing a reference where your colleague does not. Just my 2 cents...

这篇关于访问自动填充错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！