Posted: Wed Dec 16, 2009 10:15 am Post subject: WAR Workbook error
I keep getting this error when trying to add the Whirbelwind.
I fixed all the other errors but I can't seem to figure this one out.
what is the N/A from
when I try to trace it it points to ammo count and the name of the Vehicle.
The ammo count looks to be the same to me as listed in the vehicles page.
Is it because I copy/paste the formula areas in order to increase it's use for more teams?
Posted: Wed Dec 16, 2009 2:55 pm Post subject: Re: WAR Workbook error
If you copied and pasted a formula from one cell to another, then in all likelyhood the formula is wrong. It will have at least one incorrect cell reference. Some formulas can be added using Fill, but most will also have a progressive error that has to be corrected by editing.
A simple way to view the formula as typed (rather than the normal view of the formula result) for easy comparison and editing is to press Ctrl + Tilde. Tilde may not be the right name for the key. It is the one with the squiggly line on it next to the "1" key. Press Ctrl + Tilde again to return the view to formula results.
The work around for copying entire ranges of formulas from one workbook to another without changing the absolute cell references is to have both the copy from and paste to worksheets open and both in the Ctrl + Tilde view. Copy the range of formulas from the first worksheet and then paste that to NotePad. Select and copy the entire range in NotePad and then paste it to the new worksheet. Then change the view back to formula results by pressing Ctrl + Tilde again. This will give an exact copy of formulas and not create cell references to other files.
Posted: Thu Dec 17, 2009 12:40 am Post subject: Re: WAR Workbook error
First off thanks for the help,
Your post seems to refer to copying from one book to another book
Im looking to just increase the amount from 153 rows to say 200 or more.
When I copied it as you mentioned I noticed it copy's everything.
Im assuming that the numbers from the previous teams (that were copied) will be replaced as I add new teams?
Im also wondering about the "Use Infantry" and "Use Vehicle"
Will this also change as one adds a unit depending on whats selected?
I havent gotten that far yet and just want to make sure before I save it.
if you know what I mean
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
In August of 2004, Zappi, Homba, Bambam887, RedScorpion and MOOXE all pitched
in to create this Close Combat site. I would to thank all the people who have visited
and found this site to thier liking. I hope you had time to check out some
of the great Close Combat mods and our forums. I'd also like to thank
all the members of our volunteer staff that have helped over
the years, and all our users that contributed to this site!