Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gray78
  • Order by date
  1. gray78

    verify numbering sequence

    You are the best! Thank you mucho
  2. gray78

    verify numbering sequence

    sorry to be a pain, but, i am not understanding. I have two columns: column "A" contains the sequenced numbers I am checking and column "B" is currently blank but where I want the "Error in sequence" remark. 1. where do I place the formula?(for testing purposes, lets assume I have data in range...
  3. gray78

    verify numbering sequence

    Thank you, and now the stupid question of the day...How do I use the filter as you suggested? Thanks again
  4. gray78

    verify numbering sequence

    In an excel work sheet, is there a way to verify that the numbering in a column is in sequence and if a number is missing in the sequence to identify it? Thanks
  5. gray78

    inserting a range from an excel worksheet into Word

    macropod, Thank you. The problem I am running into is that I want to create a macro to do this function. If the clipboard is empty I get an error as follows: Run-time error '4605': This method or property is not available because clipboard is empty or not valid. The portion of the code in...
  6. gray78

    inserting a range from an excel worksheet into Word

    Thanks. I wasn't clear though. I want to be able to link a range of cells from a worksheet which is withing a workbook into a Word document.
  7. gray78

    inserting a range from an excel worksheet into Word

    I would like to know how to link a range of cells from an excel worksheet which is part of a workbook into a word document.
  8. gray78

    Word and Excel Macros

    Thanks, now how can I correct the problem. I want to be able to run a macro from the word document which will open the excel workbook, go to the particular worksheet, highlight a range within that worksheet, copy the range of cells, go back to the word document, paste or paste special the copied...
  9. gray78

    Word and Excel Macros

    the error occurs at: Selection.PasteSpecial Link:=False, DataType:=wdPasteOLEObject, Placement _ :=wdInLine, DisplayAsIcon:=False
  10. gray78

    Word and Excel Macros

    When I run the macro I get the following error: Run-time error '5342' The specified data type is unavailable.
  11. gray78

    Word and Excel Macros

    I currently have a word document in which I want to run a macro which will open a specific excel workbook, go to a specific worksheet, copy a range within that worksheet,then paste the copied range into the word document and then format it to fit the page in the word document. The problem I am...
  12. gray78

    macro help

    code: Sub ot_18() ' ' ot_18 Macro ' Macro recorded 4/7/2006 by dkotcher ' Selection.PasteSpecial Link:=False, DataType:=wdPasteOLEObject, Placement _ :=wdInLine, DisplayAsIcon:=False Selection.TypeBackspace Selection.InlineShapes(1).Fill.Visible = msoFalse...
  13. gray78

    macro help

    More detail: I have a monthly report being created in a MS Word document. Within this document I have several tables which are from an MS Excel worksheet. These are the tables or actually a range of cells which I am coping and pasting (through macros) into the word document. Is there a way...
  14. gray78

    macro help

    I have a word document and an excel worksheet. I am trying to create macros within the document which will go to the worksheet, copy a range of cells and paste special (microsoft office excel worksheet object) the copied cells an then format the object to fit the document. I am trying to do...
  15. gray78

    Table of contents formatting

    what do you mean by a page spread. I formatted each table with a header and that is how it came out
  16. gray78

    Table of contents formatting

    How can I format the TOC to read: Operations 2006 Overtime Table.........18-25 instead of how it is currently reading: Operations 2006 Overtime Table..........18 Operations 2006 Overtime Table..........19 Operations 2006 Overtime Table..........20 Operations 2006 Overtime...
  17. gray78

    changing dates

    unforunately this is the way the boss whats it. I would like to be able to change the dates from February (i.e. 2/1/2006 etal) to March (i.e. 3/1/2006 etal) Gray 78
  18. gray78

    changing dates

    I currently use the same workbook every day which has a worksheet for each day in the month. Is there a way to change the date (in a particular cell)on each page (for the current month) without having to do it manually? The tab for each day also has a date and I would like to change this as...
  19. gray78

    Picture in report that will not convert to word document

    Thank you. I can convert it to a PDF but really wanted to convert it to a word doc with the graphic. The reason for converting it to Word and not a PDF is so that changes can be made on the document easily for someone who only had Word on their computer. Thanks.
  20. gray78

    Picture in report that will not convert to word document

    I have an image in my report(a logo) that will not show when I use the office link to MS Word. Any suggestions how I can get this to appear? Thanks

Part and Inventory Search

Back
Top