View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
michaelberrier michaelberrier is offline
external usenet poster
 
Posts: 63
Default Dynamic + Fixed worksheet name

On Wednesday, May 25, 2016 at 5:23:46 PM UTC-4, michaelberrier wrote:
On Wednesday, May 25, 2016 at 9:51:03 AM UTC-4, Claus Busch wrote:
Hi Michael,

Am Wed, 25 May 2016 06:38:06 -0700 (PDT) schrieb michaelberrier:

Ok, this will be an elementary question, but how do I get the private sub to run? I've tried doing a "Call" module, but it fails.


the macro runs when you change A1


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


It does not change.


Rather, the macro doesn't run when the reference cell changes