Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro: search word, select row, copy.
I'm tryingo to write a macro in excel which: -Finds a word in the file -Selects the row which contains the word -Changes the color of the row -Copy the entire row I have this: Cells.FindNext(After:=ActiveCell).Activate With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With Selection.Copy End Sub but i can't seem to figure out how to select only the row which contains the word. If I select the entire row, the macro will always copy that same row [' Rows(4)' will select always row 4. 'Rows' will select all the rows...] Comments? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Excel and copy result into word | Excel Programming | |||
macro to intsert a word using the "Find" command to search for a word | Excel Programming | |||
macro to search for & select ranges to sum | Excel Programming | |||
search for a specific word and copy the word and the preceeding words until a comma | Excel Programming | |||
select all & copy in word from macro in excel | Excel Programming |