ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need assist with setting cell values from an addin subroutine (https://www.excelbanter.com/excel-programming/318798-need-assist-setting-cell-values-addin-subroutine.html)

[email protected]

Need assist with setting cell values from an addin subroutine
 
Hello,

This ought to be an easy one!

I can set a cell in a my vbaproject in a subroutine using the common:

Worksheets("Sheet").Cells(R,C).Value = "this"

However, the same code placed in a subroutine in an addin used by the
vbaproject has no effect.
Why is that?

Any help appreciated,
Jeff Stryer


Bob Phillips[_6_]

Need assist with setting cell values from an addin subroutine
 
Are you referring to the correct workbook. You may be setting a value in the
add-in's worksheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Hello,

This ought to be an easy one!

I can set a cell in a my vbaproject in a subroutine using the common:

Worksheets("Sheet").Cells(R,C).Value = "this"

However, the same code placed in a subroutine in an addin used by the
vbaproject has no effect.
Why is that?

Any help appreciated,
Jeff Stryer





All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com