Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting cell values based on a 3rd cell | Excel Worksheet Functions | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
Dynamically setting CELL COLORS based on TWO OTHER cell values | Excel Discussion (Misc queries) | |||
Setting values in a cell | Excel Discussion (Misc queries) | |||
Worksheet Cell Range Name within VB Subroutine | Excel Discussion (Misc queries) |