| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot find Cell
Sorry for this easy question, but the months of Access Programming has warped
my mind of the many things I remembered in Excel. If I want to find the word "Date", what do I need to add to my VB. Thanks! With ActiveSheet.Range("a1:a50") Set C = .Find("Date", LookIn:=xlValues) ActiveCell.EntireRow.FillUp.Select Selection.Delete shift:=xlUp Secondly, will the second part of my code delete all the rows above the "Date" row? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
| use find twice to find cell on a specific row | Excel Programming | |||
![Kou Vang[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
