Recent content by gray78

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