problem with selecting something

S

solo_razor

hi,

I have a problem regarding selecting something.
I want to search in a excel sheet for a certain value e.g.
"description" Now i want to select everything under this cell
"description"
I got so far:
If Worksheets("sheet1").Cells.Find(What:="Description",
After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=
_
False).Activate Then
???????????????????

Can anybody help me?

Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Getting Excel Find to Default to Searching Workbook not Sheet 3
Find copy data from a cell in Personal workbook and copy it to a cellin current workbook 14
Need help with correct syntax please 2
Using While Wend with Cells.Find 1
Worksheet_Change Woes 6
If Then using "Find" command 5
Range With Variables 1

Top