I am working on a excel staff structure that has an issue with
changing formulas and VB programming. All formula cells are protected
and half are hidden
but every so often a reference will disapear from a formula. It is
never the same column or row and is only used by only 1 person per
shop no other interferance can be traced. Sometimes it can occour on
a
page that has not been modified.
here is a copy of the formula
=Hours_Worked($A81,C81,C82,$A$2)
hours_worked is the vba part of the program to work out the number of
hours worked and the remainder are reference cells
=Shift_Pay($A81,C$4,C81,C82,$G$2,$D$3,$A$2) +$K84/7
shift_pay works out the pay rates and any penalities in vba and gives
a $ figure

=Hours_Worked($A81,#REF!,#REF!,$A$2)
this is what I get which gives the errors
=Shift_Pay($A81,D$4,#REF!,#REF!,$G$2,$D$3,$A$2) +$K84/7


it is very random when and where it happens, It's like there is a
ghost in it doing what it wants
can any one help me?

I have now had 1 line of code changed and I dont know why
The line of code replaced "." with "<>"
and replaced "<>" with "="
Why or how did this happen?

You have responses at your other thread.

PJG wrote:
>
> I am working on a excel staff structure that has an issue with
> changing formulas and VB programming. All formula cells are protected
> and half are hidden
> but every so often a reference will disapear from a formula. It is
> never the same column or row and is only used by only 1 person per
> shop no other interferance can be traced. Sometimes it can occour on
> a
> page that has not been modified.
> here is a copy of the formula
> =Hours_Worked($A81,C81,C82,$A$2)
> hours_worked is the vba part of the program to work out the number of
> hours worked and the remainder are reference cells
> =Shift_Pay($A81,C$4,C81,C82,$G$2,$D$3,$A$2) +$K84/7
> shift_pay works out the pay rates and any penalities in vba and gives
> a $ figure
>
> =Hours_Worked($A81,#REF!,#REF!,$A$2)
> this is what I get which gives the errors
> =Shift_Pay($A81,D$4,#REF!,#REF!,$G$2,$D$3,$A$2) +$K84/7
>
> it is very random when and where it happens, It's like there is a
> ghost in it doing what it wants
> can any one help me?
>
> I have now had 1 line of code changed and I dont know why
> The line of code replaced "." with "<>"
> and replaced "<>" with "="
> Why or how did this happen?

--

Dave Peterson

Hard to tell without seeing.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"PJG" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am working on a excel staff structure that has an issue with
> changing formulas and VB programming. All formula cells are protected
> and half are hidden
> but every so often a reference will disapear from a formula. It is
> never the same column or row and is only used by only 1 person per
> shop no other interferance can be traced. Sometimes it can occour on
> a
> page that has not been modified.
> here is a copy of the formula
> =Hours_Worked($A81,C81,C82,$A$2)
> hours_worked is the vba part of the program to work out the number of
> hours worked and the remainder are reference cells
> =Shift_Pay($A81,C$4,C81,C82,$G$2,$D$3,$A$2) +$K84/7
> shift_pay works out the pay rates and any penalities in vba and gives
> a $ figure
>
> =Hours_Worked($A81,#REF!,#REF!,$A$2)
> this is what I get which gives the errors
> =Shift_Pay($A81,D$4,#REF!,#REF!,$G$2,$D$3,$A$2) +$K84/7
>
>
> it is very random when and where it happens, It's like there is a
> ghost in it doing what it wants
> can any one help me?
>
> I have now had 1 line of code changed and I dont know why
> The line of code replaced "." with "<>"
> and replaced "<>" with "="
> Why or how did this happen?
>

On May 4, 9:27 pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
> Hard to tell without seeing.
>
> --
> Don Guillett
> SalesAid Software
> dguille...@austin.rr.com"PJG" <petergra...@iinet.net.au> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >I am working on a excel staff structure that has an issue with
> > changing formulas and VB programming. All formula cells are protected
> > and half are hidden
> > but every so often a reference will disapear from a formula. It is
> > never the same column or row and is only used by only 1 person per
> > shop no other interferance can be traced. Sometimes it can occour on
> > a
> > page that has not been modified.
> > here is a copy of the formula
> > =Hours_Worked($A81,C81,C82,$A$2)
> > hours_worked is the vba part of the program to work out the number of
> > hours worked and the remainder are reference cells
> > =Shift_Pay($A81,C$4,C81,C82,$G$2,$D$3,$A$2) +$K84/7
> > shift_pay works out the pay rates and any penalities in vba and gives
> > a $ figure
>
> > =Hours_Worked($A81,#REF!,#REF!,$A$2)
> > this is what I get which gives the errors
> > =Shift_Pay($A81,D$4,#REF!,#REF!,$G$2,$D$3,$A$2) +$K84/7
>
> > it is very random when and where it happens, It's like there is a
> > ghost in it doing what it wants
> > can any one help me?
>
> > I have now had 1 line of code changed and I dont know why
> > The line of code replaced "." with "<>"
> > and replaced "<>" with "="
> > Why or how did this happen?- Hide quoted text -
>
> - Show quoted text -

if any one would like a copy to see if they can find what is wrong
with it let me know

On May 4, 9:27 pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
> Hard to tell without seeing.
>
> --
> Don Guillett
> SalesAid Software
> dguille...@austin.rr.com"PJG" <petergra...@iinet.net.au> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >I am working on a excel staff structure that has an issue with
> > changing formulas and VB programming. All formula cells are protected
> > and half are hidden
> > but every so often a reference will disapear from a formula. It is
> > never the same column or row and is only used by only 1 person per
> > shop no other interferance can be traced. Sometimes it can occour on
> > a
> > page that has not been modified.
> > here is a copy of the formula
> > =Hours_Worked($A81,C81,C82,$A$2)
> > hours_worked is the vba part of the program to work out the number of
> > hours worked and the remainder are reference cells
> > =Shift_Pay($A81,C$4,C81,C82,$G$2,$D$3,$A$2) +$K84/7
> > shift_pay works out the pay rates and any penalities in vba and gives
> > a $ figure
>
> > =Hours_Worked($A81,#REF!,#REF!,$A$2)
> > this is what I get which gives the errors
> > =Shift_Pay($A81,D$4,#REF!,#REF!,$G$2,$D$3,$A$2) +$K84/7
>
> > it is very random when and where it happens, It's like there is a
> > ghost in it doing what it wants
> > can any one help me?
>
> > I have now had 1 line of code changed and I dont know why
> > The line of code replaced "." with "<>"
> > and replaced "<>" with "="
> > Why or how did this happen?- Hide quoted text -
>
> - Show quoted text -

would you like a copy