| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells.find help
I am trying to do this. Once I run this command:
Cells.Find(What:="Average Totals", After:=ActiveCell, LookIn:=xlFormulas _ , LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate It will activate whatever cell it finds "Average Totals" in. Once this happens I want the macro to take that row and make it active so I can insert a row. How can I do it? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cells.find help
Hi,
does this help? Cells.Find(What:="Average Totals", After:=ActiveCell, LookIn:=xlFormulas _ , LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).entirerow.insert shift:=xlshiftdown Regards, Ivan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cells.find help
Perfect! Thanks
Ivan Raiminius wrote: Hi, does this help? Cells.Find(What:="Average Totals", After:=ActiveCell, LookIn:=xlFormulas _ , LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).entirerow.insert shift:=xlshiftdown Regards, Ivan -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cells.find help
Cells.Find(What:="Average Totals", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).EntireRow.Activate HTH -- AP "erikkeith via OfficeKB.com" <u13156@uwe a écrit dans le message de news: 5fca0f6998692@uwe... I am trying to do this. Once I run this command: Cells.Find(What:="Average Totals", After:=ActiveCell, LookIn:=xlFormulas _ , LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate It will activate whatever cell it finds "Average Totals" in. Once this happens I want the macro to take that row and make it active so I can insert a row. How can I do it? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Cells.find to find first number in a row which is 8000 | Excel Discussion (Misc queries) | |||
| how to find cells that refer to data in other cells in excel | Excel Discussion (Misc queries) | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| How to find multiple cells/replace whole cells w/data | Excel Discussion (Misc queries) | |||
| If Cells.Find can't find anything | Excel Programming | |||
Hybrid Mode
