Search results for query: *

You are the best! Thank you mucho

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...

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

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

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...

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.

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.

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...

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

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

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...

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...

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...

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...

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

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...

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

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...

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.

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