Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find word copy and paste
Hello
Excel 2003 I have a sheet with six columns with 700 rows each with text. I have to red all rows to find a word and copy and paste in the same cell of column b. This is really heavy task and the risk of error is a problem. I 'm looking for a code to do this task. I have been trying the code from Ron de Bruin I found in this forum but when I run the code this message is displayed: Run-time error :1004: Application defined or object defined error I am learning VBA, I don't know hot to fix the error. Your help is welcome First I have been trying the search with in one column I have a Sheet with 6 columns (F,G,H,I) with 700 rows. I need a code to do this: 1. Read F:1 if find the word Apple, Then copy and paste the word in cell B:1 2. Go to F:2 if find the word Apple, Then copy and paste the word in cell B:2 3. Same until F700 If possible do the same application in Columns G, H, I |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find a word and copy all rows with this word to diff ws | Excel Programming | |||
Find/Copy/paste.. then Find/Paste - not working ... at all.... | Excel Programming | |||
Won't let me copy and paste from Excel to Word | Excel Discussion (Misc queries) | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Copy And Paste From Excel To Word | Excel Programming |