| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting after Find Method
How do I select the entire row of C after I find and select it? Thanks
Set C = .Find("Date", LookIn:=xlValues) If C Is Nothing Then MsgBox "Not Found!" Else C.Select |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting after Find Method
C.Entirerow.Select
-- HTH... Jim Thomlinson "Kou Vang" wrote: How do I select the entire row of C after I find and select it? Thanks Set C = .Find("Date", LookIn:=xlValues) If C Is Nothing Then MsgBox "Not Found!" Else C.Select |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting after Find Method
I swear I tried that! But thanks again JIM!!! Once again, Access VBA is
frying my brains! "Jim Thomlinson" wrote: C.Entirerow.Select -- HTH... Jim Thomlinson "Kou Vang" wrote: How do I select the entire row of C after I find and select it? Thanks Set C = .Find("Date", LookIn:=xlValues) If C Is Nothing Then MsgBox "Not Found!" Else C.Select |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting after Find Method
One more thing, if I wanted to select everything above C, then would I use an
autofill to do this? "Jim Thomlinson" wrote: C.Entirerow.Select -- HTH... Jim Thomlinson "Kou Vang" wrote: How do I select the entire row of C after I find and select it? Thanks Set C = .Find("Date", LookIn:=xlValues) If C Is Nothing Then MsgBox "Not Found!" Else C.Select |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting after Find Method
Nope you don't need the autofill for that matter you do not need the select.
With ActiveSheet.Range("a1:a50") Set C = .Find("Date", LookIn:=xlValues) If C Is Nothing Then MsgBox "Not Found!" Else activesheet.Range("A1", C).entirerow.delete -- HTH... Jim Thomlinson "Kou Vang" wrote: One more thing, if I wanted to select everything above C, then would I use an autofill to do this? "Jim Thomlinson" wrote: C.Entirerow.Select -- HTH... Jim Thomlinson "Kou Vang" wrote: How do I select the entire row of C after I find and select it? Thanks Set C = .Find("Date", LookIn:=xlValues) If C Is Nothing Then MsgBox "Not Found!" Else C.Select |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting after Find Method
Kou Vang,
Use C.EntireRow.Select Regards Ian -- Work performed in the spirit of service is worship...Baha''''i Writings "Kou Vang" wrote: How do I select the entire row of C after I find and select it? Thanks Set C = .Find("Date", LookIn:=xlValues) If C Is Nothing Then MsgBox "Not Found!" Else C.Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date find using find method | Excel Programming | |||
| Selecting a Range using Inputbox Method | Excel Programming | |||
| Using variables to make a date and using find method to find that. | Excel Programming | |||
| Method of selecting an area with a macro | Excel Worksheet Functions | |||
| The Find Method | Excel Programming | |||
![Kou Vang[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
