First New Post
 

Hi, I posted my first question to the newsgroup yesterday morning with this
subject: Variable Acting Like a Constant? I don't expect an answer in such
a short time, but I don't see my posting under sent October 13, 2005 or
anywhere on the list yet. How long does a new question usually take to be
shown on the list? Thanks, George

First New Post
 

George Boynton skrev:

Hi, I posted my first question to the newsgroup yesterday morning with this
subject: Variable Acting Like a Constant? I don't expect an answer in such
a short time, but I don't see my posting under sent October 13, 2005 or
anywhere on the list yet. How long does a new question usually take to be
shown on the list? Thanks, George

Hi George,


Using Google Groups I can see it... Think you got an answer too :)

/impslayer

First New Post
 

i see it using outlook express in the ms programming ng. bob answered you
last evening.

--


Gary


"George Boynton" wrote in message
...
Hi, I posted my first question to the newsgroup yesterday morning with
this
subject: Variable Acting Like a Constant? I don't expect an answer in
such
a short time, but I don't see my posting under sent October 13, 2005 or
anywhere on the list yet. How long does a new question usually take to be
shown on the list? Thanks, George

First New Post
 

George, I replied yesterday. I was having problems with my time setting
which may have thrown it. My response was

You have to execute the code that sets myRow again whenever the data
changes, or more appropriately, just prior to the code that uses that
variable.

Variables are not event driven, that is they do not update when whatever
they refer to changes.



--

HTH

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


"George Boynton" wrote in message
...
Hi, I posted my first question to the newsgroup yesterday morning with
this
subject: Variable Acting Like a Constant? I don't expect an answer in
such
a short time, but I don't see my posting under sent October 13, 2005 or
anywhere on the list yet. How long does a new question usually take to be
shown on the list? Thanks, George

First New Post
 

George I only just replied to your original post. Check it out, perhaps it's
something you can use.

"George Boynton" wrote:

Hi, I posted my first question to the newsgroup yesterday morning with this
subject: Variable Acting Like a Constant? I don't expect an answer in such
a short time, but I don't see my posting under sent October 13, 2005 or
anywhere on the list yet. How long does a new question usually take to be
shown on the list? Thanks, George

First New Post
 

Jusy to add

Think of a variable as being like a piece of paper. When you observe
something, you write it down.

When what you observe changes, what is written on the paper doesn't change
until you change it. It is the same with variables. They capture the value
at the time they are set. You then have to execute similar code to update
that value.

The one approach that can overcome this is to use a dynamically assigned
defined name/range
Insert = Name=Define
Name: Table1
Refersto: =Offset(Sheet1:$A$1,0,0,CountA(sheet1:$A$1:$A$200) ,10)

Everythime there is a recalculation in the spreadsheet, then the named range
should update to reflect the current extent of the range. It is then used
in code as

If Range("Table1").Rows.count 30 then

as an example.

--
Regards,
Tom Ogilvy

"George Boynton" wrote in message
...
Hi, I posted my first question to the newsgroup yesterday morning with
this
subject: Variable Acting Like a Constant? I don't expect an answer in
such
a short time, but I don't see my posting under sent October 13, 2005 or
anywhere on the list yet. How long does a new question usually take to be
shown on the list? Thanks, George

First New Post
 

i don't think that was it, bob. the ng had some issues yesterday. all of a
sudden last night, i got about 40 new posts from various times. an i had
just checked not too long before that.

--


Gary


"Bob Phillips" wrote in message
...
George, I replied yesterday. I was having problems with my time setting
which may have thrown it. My response was

You have to execute the code that sets myRow again whenever the data
changes, or more appropriately, just prior to the code that uses that
variable.

Variables are not event driven, that is they do not update when whatever
they refer to changes.



--

HTH

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


"George Boynton" wrote in message
...
Hi, I posted my first question to the newsgroup yesterday morning with
this
subject: Variable Acting Like a Constant? I don't expect an answer in
such
a short time, but I don't see my posting under sent October 13, 2005 or
anywhere on the list yet. How long does a new question usually take to
be
shown on the list? Thanks, George