If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula
I am trying to do a simple formula of one cell multiplied by another cell on a form/table that has already been designed. Quantity x Cost to =, but I can't figure out what cell I am in. In Excel there was a section that told you what cell you were in A23 or B19. I have tried everything I can think of and it keeps coming back with *Syntax Error - Any suggestions?
Also this table is going to be used by lots of people and I would like to lock some cells so that they cannot change and it would be nice to just hit the tab key and go to a field that they need to enter information in. Any way to do that? |
#2
|
|||
|
|||
Formula
Hi Deb,
MS (I think) produced a macro for returning table cell addresses. The copy I have uses the following code: Sub CellAddress() If Selection.Information(wdWithInTable) = True Then StatusBar = "Cell Address: " & Chr(64 + Selection.Cells(1).ColumnIndex) & Selection.Cells(1).RowIndex End If End Sub As for your syntax error result, that may or may not be due to incorrect cell addresses. In Word, for example, you don't use $ symbols to indicate an absolute address - cell addresses in Word are absolute by design. If your Quantity and Cost values are in A23 and B19, for example, the field coding would be: {=A23*B19} where the field braces are created via Ctrl-F9 For more of Word field maths, check out the Word document at: http://www.wopr.com/cgi-bin/w3t/show...&Number=365442 (url all one line) Cheers "Deb" wrote in message ... I am trying to do a simple formula of one cell multiplied by another cell on a form/table that has already been designed. Quantity x Cost to =, but I can't figure out what cell I am in. In Excel there was a section that told you what cell you were in A23 or B19. I have tried everything I can think of and it keeps coming back with *Syntax Error - Any suggestions? Also this table is going to be used by lots of people and I would like to lock some cells so that they cannot change and it would be nice to just hit the tab key and go to a field that they need to enter information in. Any way to do that? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.718 / Virus Database: 474 - Release Date: 9/07/2004 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting a SUMPRODUCT formula to COUNTA active... | BeSmart | Worksheet Functions | 8 | March 27th, 2004 03:36 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |
Offset formula | Frank Kabel | Worksheet Functions | 5 | March 15th, 2004 09:50 PM |
Dynamic formula to sum across rows | turtleman2 | Worksheet Functions | 5 | March 8th, 2004 08:11 PM |
Sheet Names | Joseph M. Yonek | Worksheet Functions | 6 | January 3rd, 2004 02:15 AM |