line and column numbers


In Word'03 I am trying to find out how you would insert text into a
document at line and column number reference points . 

so I know that on page 1 and 2 and 3 I would like to enter the value of
"1" at Ln 1 Col 35 how would I do this in VBA code. 

Thanks for your help. 


robhargreaves's Profile:
View this thread:

8/2/2005 12:49:07 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 51

The best way is to cheat: record the macro to do exactly what you need
it to do for page 1, review the VBA code that automatically generates,
and revise the code to repeat for pages 2 and 3.  All this after you
make a backup of your data so as not to lose critical information.

Also, you may find better answers to MS Word questions on the MS Word

CycleZen (674)
8/2/2005 2:08:50 PM

Similar Artilces:

How do I make numbers become text?
I am trying to create a spreadsheet where numbers entered in one location become text in another. I tried the Help option, but I am still lost. Please help, and thank you. From earlier postings: How to Convert a Numeric Value into English Words;EN- US;140704& and: (courtesy of a cut and paste from a Tom Ogilvy post): If you want an addin that provides a worksheet function that does this, download Laurent Longre's free morefunc.xll addin found here: It is downloaded in a zip file which also conta...

Is there a way to change an imported number such as: 7042626598 and display it as a phone number like: (704) 262-6598 ? Thank you, Be -- Message posted from Ben, Yes you can format the cells containing the 10 digit number to a phone number. Highlight all the required cell and on the Main menu choose Format/Cells/Number/Special/Phone Number Charlie O'Neill >-----Original Message----- >Is there a way to change an imported number such as: > >7042626598 and display it as a phone number like: > >(704) 262-6598 > >? > > >...

BCP Computed Column
Hi. I have a table with a computed column. When I try to import data into table through BCP it generates error due to computed column. So how to handle a computed column while importing data into table through bcp from a text file. Regards, Muhammad Bilal You need to use a format file that tells BCP to skip that column. See BOL for info on bcp format files. Tom "Muhammad Bilal" <> wrote in message > Hi. > > I have a table with a computed column...

data labels from second column
Hi Column A is list of names (Bob, Sue, etc); column B is how much they collected (58, 12, etc); Column C is the date they did it on - so record 1 says Bob collected 58 on 10/07/07, for instance. I want to create a chart with the date for the x axis, amount collected as the y axis and data labels at each point within the graph giving the collector's name. So at X=12/07/07, y=58 I want it to say Bob within the chart area. Any help much appreciated. Regards Chandler On Mon, 3 Sep 2007, in microsoft.public.excel.charting, Chandler <> said: &...

Seeding Random Numbers with Multiple Threads?
Hi, Usually, seeding the random number generator with a time value is ideal as it creates what is for all practical purposes, true random numbers. However, each thread has it's own random number seed. And, I need to seed 4 seperate threads during initialization of my app. So using the time doesn't work, as all four threads end up using the exact same (therefore non-random) series of numbers. Is there a best practice for what seed(s) to use when seeding several random generators at once? Are there three more different, but unpredictable UINT values in the system that I could seed the...

Sequential number
Is there a way to squentially number a column so that if you insert or delete rows in the middle the numbers will readjust? if you use A1+1 and copy it down, you get a #REF if you delete; and a blank cell if you don't (and then you have to use the fill handle from above the blank cell to resequence? Any assistance would be greatly appreciated. Suzan Enter the formula =ROW() in the first cell and copy it down. (You might like to add or subtract a constant depending on how you want the cells numbered). When you delete a row this will automatically re-number. If you insert a row, thoug...

How do i hlookup with the "row index number" changing
i want to combine 2 worksheets, so i want to do a hlookup the headings of the colums are the same but are ordered differentl (from a data dump) thats why i can't do a straight copy and paste. i need my formula to do something like this Row 1 contains the column headings Row 2 to 1999 contains data from the 1st file Sheet1 contains data from the 2nd file. a2000=HLOOKUP($A$1,Sheet1!$A:$AJ,2,FALSE) a2001=HLOOKUP($A$1,Sheet1!$A:$AJ,3,FALSE) a2002=HLOOKUP($A$1,Sheet1!$A:$AJ,4,FALSE) notice the row index number changes how do i create a formula where the row index number +1 for eac ite...

Item level revision numbers on POs
The Item Engineering info on inventory items in manufacturing includes revision numbers for items, however because that info is in the manufacturing dictionary we can't include through report writer on POs. I'd like to develop a routine that would copy the revision number from the item engineering table to one of the user-defined tables in inventory. Any suggestions on how to do that? Or an alternate approach to the problem? -- Jim@TurboChef Jim- This script will put the current Rev level from Item Engineering into User Category 1 on the item master. update iv00101 set usca...

Step Line Charts
Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vertical. Hi Carrie, You Will need some form of extra data to get excel to create a step chart. Take a look at these methods. ( Carrie wrote: > Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vert...

Comparing Values In 2 Columns
Hi, i have 2 list of students names both of which are not up to date with each other and because of this one list has more students than the other. I want to search for students names and see if there is a match, if a match is found i need to copy the email address and paste it into the cell by the other name in the other list. See Below My spreadsheet has columns titled, (A)Display Name, (B)Display Email, (C)Sims Name and (D)Sims Email. I basically want to write a script that takes each individual display name in column A and searches in column C for an identical match, if a match is found i...

Conver Numbers to Log 10
How do I convert column of numbers (n=3000) to log 10 column of numbers? Assuming that your column is column A, one way: In an unused column, enter =LOG(A1) and copy down 3000 cells. Copy the column, choose column A and choose Edit/Paste Special, selecting the Values radio button. In article <>, "Fishfan" <> wrote: > How do I convert column of numbers (n=3000) to log 10 column of numbers? ...

error numbers
Does anyone know if microsoft has a way to look up errors and their resolution by ERROR NUMBER? I have never found anything like that. Now they have something called "Events and Errors Message Center" but even that doesn't appear to let one look up errors by error number! Thanks Hi, Fredrated schrieb: > Does anyone know if microsoft has a way to look up errors and their > resolution by ERROR NUMBER? > > I have never found anything like that. Now they have something called > "Events and Errors Message Center" but even that doesn't appear to...

Lines of text move when viewed in print preview and printed
I am inserting pictures with-in paragraphs of text. I have tried formating as both exact and in-line, using top/bottom. The text moves up 1-2 lines when printed or viewed in print preview. This change in text lines also happens when view is changed from 50% to 100%. I am working with two column text and the pictures are inserted into each column. How can I fix this problem? What version of Windows and Publisher are you using??? You people that think we have crystal balls or are mind readers are exasperating! -- >-----Original Message----- >What version of Windows and Publi...

What is the maximum number of users that can share Excel File?
According to the Excel Help file, all users on your network, unless you restrict the number. "pfine" wrote: > ...

lookup row number
Hi, can you tell me how to lookup the row number of a name in a list. EG say I have a list of names as below: Andrew Mike Steve Ian Paul I would normally just add a column with the row numbers and then lookup the row number in the second column but is it possible to do without adding the extra column by using the row formula someohow? Thanks Hi Michael Try the below.. =MATCH("Mike",A:A,0) -- Jacob (MVP - Excel) "Michael" wrote: > Hi, > can you tell me how to lookup the row number of a name in a list. > > EG say I hav...

How can I compare the column names from 2 tables and output them?
I have a requirement to place an alert if the field does not exist in my table, tblStaging. Can any one guide me to reframe this query with error handling messages? I know it is not good practice to use select * but I need to do this as my columns\field names change each time. INSERT INTO tblStaging SELECT * FROM tbl_XL,tblDetails; Thank you -- Message posted via Access is a relational database. If your "table design" has the fields in your table(s) changing frequently,...

Pivot Table and adding a % column, that is not in original data
Hi, Is it possible to add a column for % calculations when the % column is not in original data? To clarify, my original data is as follows: Produt Sales Returns Date A 5 June B 6 June A 1 July A 1 September B 1 November When I run the pivot table, one of the columns I'm then looking to get is a total % of returns over sales , but I cant see how to include in a Pivot table. I can add it outside of the table, but that has problems ...

Maximum number of bits
I have a requirement to find the maximum number of consecutive zeros in a row in a 32 bit binary number. For example 1111 1111 1111 1000 1111 1111 0000 1111 = 4 1111 1110 1111 1110 1111 1111 1110 1111 = 1 I am actually storing the number in a BIGINT for simplicity. I can do this in a udf with a look fairly easily but was wondering if there is something more sql that will do the job. Cheers, Michael That's an interesting question. Does it include leading zeroes? 0000 0000 0111 1000 1111 1111 0000 1111 = 9? -- Thanks Michael Coles SQL Server MVP ...

can one cell contain more than one independent number
A cell can contain several numbers, separated by space characters or line breaks (Alt+Enter). However, if you want to perform calculations on the numbers, it's best to keep them in separate cells. John K wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List there's also the option a using matrix formula (list of data) for example you may enter ={1;2;3} in a single cell or selection 'and validate wih CTRL+SHIFT+ENTER but the manipulation of this kinda of formula need to read more about it... ...

Customize global adress list column in a new mail
Hi! (I have Outlook 2007 and Exchange 2007). when i create a new mail message, hit the "To" button, my global adress list window appear when column by default: Name, Title, business Phone, Location, E-mail address, Company and Alias. Those column from Active directory of course. My question is: can I add/remove column in this window? For example adding "department" from Active directory? thx Since this is customized by your Exchange Admin, I would start by asking him/her if it is possible. This question can most likely be answered in an Exchange or W...

finding common numbers in large lists
Hello, I have two large lists of numbers (on two seperate worksheets). By large, I mean that one list is 1000+ numbers, and the second list is 3000+ numbers (each number is in its own cell). The numbers are of the form: (that is, they are precise up to three places after the decimal) 1) Is there some quick way that I can find the numbers that are common to both lists? 2) Is there a way I can find the numbers in common to both lists using only the whole number portion (diregarding what comes after the decimal of each number)? Thanks! Hi see:

Two lines and pne column
I am trying to modify one of the custom charts to show two line and one column rather than two columns and one line. can anyone help. Ian - Forget the custom type. Make a chart with all three series as lines, select the one series, choose Chart Type from the Chart menu, and select the Column style you want. Voila, your first custom combination chart. There's more about Combination Charts on my web site: - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech....

creating a multilevel numbering sysem
I'm trying to create a multileve numbering system ex: 100, 100.1, 100.1.1, 100.2, 200, 200.1, 2001.1, 200.2, and so on. I would like to have at least 3-4 tiers under each number that would automatically number. And you want this in Publisher? I don't think so... -- Mary Sauer MSFT MVP news:// "v" <> wrote in message > I'm trying to create a multileve numbering system > ex: 100, 100.1, 100.1.1, ...

Monthly contract lines
Hello, I need to be able to provide my clients 60 minutes allotments each month, then start again with a clean set of 60 minutes each month. What is the best way of doing this? I.e. perhaps automatically create a new contract line each month? Thanks for your recommendation Tony ...

extracting numbers from a text field and applying formula
here's my question... i have a cell that has a text field of this type: '9-19' (a-b) I want to create a formula that will subtract 19-9 (b-a) and return the result as a number// can anyone help?! is this even doable? I'd really appreciate it! PS also, i'm very fairly new at excel so a detailed response with th formula would really help! ALe ----------------------------------------------- ~~ Message posted from ~~View and post usenet messages directly from Try: =MID(A1,FIND("-",A1)+1,99)-LEFT(A1,FIND("...