Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
setting cell values based on a 3rd cell Bob Excel Worksheet Functions 4 March 30th 10 08:53 PM
Call a subroutine using variable subroutine name dhstein Excel Discussion (Misc queries) 3 July 26th 09 08:28 PM
Dynamically setting CELL COLORS based on TWO OTHER cell values Tom Excel Discussion (Misc queries) 3 February 22nd 09 07:34 PM
Setting values in a cell Stephen Excel Discussion (Misc queries) 3 July 10th 08 08:23 PM
Worksheet Cell Range Name within VB Subroutine Jay Somerset Excel Discussion (Misc queries) 5 February 6th 06 02:27 PM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"