First New Post

[George Boynton]

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

 

[impslayer]

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

 

[Gary Keramidas]

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

 

[Bob Phillips]

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)

 

[Guest]

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

 

[Tom Ogilvy]

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.

 

[Gary Keramidas]

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.