| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find-Copy and Paste
worked like a charm!! Thanks so much Otto!!!!
"Otto Moehrbach" wrote: Tasha This macro will find the first instance of "Date" in Column A and will place the contents of Column B of the same row, into cell D2. Watch out for word wrap. This macro has only one line besides the Sub and End Sub lines. HTH Otto Sub GetDate() Range("D2").Value = Columns("A:A").Find(What:="Date", LookAt:=xlWhole).Offset(, 1).Value End Sub "Tasha" wrote in message ... I am trying to create a macro that will find the word "DATE" in column A, then copy the date in the cell adjacent to it in the same row to cell D2. Can someone help me with this, I've looked for roughly 2 hours on how to accomplish and haven't gained any ground....Thanks for your help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Copy and Paste | New Users to Excel | |||
| Find/Copy/paste.. then Find/Paste - not working ... at all.... | Excel Programming | |||
| Find, copy and paste | Excel Discussion (Misc queries) | |||
| Find Copy and Paste | Excel Programming | |||
Hybrid Mode
