Code doesn't update from a cell?

[Macdave_19]

Hi guys,

i have this code:

Please Login or Register  to view this content.

Now when i change range G7 from E to G the code still pics up an account that has a G? i have to then exit and press "get account" again to get the desired results?

i figure this is like a refresh problem? any ideas?

Cheers for reading my thread!!

[Dav]

G7 is not referenced in your code, so it is difficult to give an answer. DO you mean G7 to E7 ot the value of the cell G7 to E from G. G7 is not directly referenced in your code so I am not sure what you are asking

Regards

Dav