asddsa88
03-07-2010, 07:14 AM
Got a new problem...
I want to create a macro that:
1)searches only in column "A" a specified text that the user inputs via a textbox popup
2)selects all the cells that contain that value
3)expands the selection from the cells to their respective rows (this is simple..)
ideas?
I just figured out point 3:
Activecell.Offset(0, 7).Select
any ideas regarding the first two steps?
thanks in advance!
I want to create a macro that:
1)searches only in column "A" a specified text that the user inputs via a textbox popup
2)selects all the cells that contain that value
3)expands the selection from the cells to their respective rows (this is simple..)
ideas?
I just figured out point 3:
Activecell.Offset(0, 7).Select
any ideas regarding the first two steps?
thanks in advance!