Recent content by VictoriaLJones

Hi Russ, Ditto for me - we have the exact same problem, with no option of re-installing MS Office. Have also encountered this at other companies, and have no idea how to resolve the issue other than re-open it etc. Which is a pain as my users keep forgetting this and are raising support...

Thank-you!! Stars for you all...... :o)

Hi, I have found something similar to this, but refering to MS Word, and as i have never coded in Word, am not sure how to extrapolate the code and change into an Excel reference etc. Basically I have worked out the code to loop through each cell in a specific range. However, assuming I am...

Thank-you!! Am sure will be of great help... Star for you!

Yes, I think that is the way I will have to go. Could you please post the code - me being lazy!! Many thanks for all your help! Victoria

Thanks for that JR. Can I change the registry to accept a ".***" ending as the F16 denotes a date and it will change daily. Or does each type need to be hard coded. Thanks Victoria

Try searching in the Microsoft VBA forum. There are a number of entries that display how you could do this - using different methods, including some complete with code to print out a spreadsheet containing all the differences. Victoria

Hi, I have been asked to help with a db conversion from NT & v97 to XP & v2000/2. Prior to converting the db, the team used to import a text file with a .F16 (The exact ending will be determined by the date, so I cannot hard code .F16 as an option) file ending, which is a text file. However...

Wondering if anyone can throw any light on to the following. We have an organisation chart in a Word 97 documant. When viewed via NT and Word 97, looks fine, and can be edited correctly via the org chart editing functionality in Word 97. However we have recently upgraded to XP and 2002. Now...

Tony, Sorry I didnt get back to you yesterday, all got a bit crazy here in the afternoon - XP migration!!! Your final post has done the trick - THANK YOU!!! :o) Star from me!!! Victoria

Ooops!! I should also mention that column L refers to the column containing the "Match" data/values Thanks Victoria

Tony, OK, here is some additional examples - sorry!! Below you will see an entry where the value is "330". There are no matched vlaues or multiple entries of that value. In my version of the formula I flag the value as 1 sided if the cell above does not match...

Tony, Many thanks for that - it works except for one thing. It now highlights them all as Multiple and I am loosing the option to pick out if the entry is "One Sided", i.e. it is a single entry, as per my previous IF statements. I am trying to incorporate the two, but having a few...

I'm not sure if this is the correct forum, but thought would give it a try. I am trying to write some formula's into a spreadsheet (that will eventually be automated). What I am trying to do is pick up where there are multiple entries of the same value, but the number of times it appears is an...

Had a feeling that was the answer!! ;o) Thanks for your help though!