|
|
|
|
#1
11-19-2013, 01:11 AM
|
|||
|
|||
select statement in macro
Hi
Receive a report in Excel every week, I have to remove some of the rows which is not relevant to division. I want to record a macro to do this, but when I record it the code would like this: If Range("A12").select Selection.EntireRow.Delete I want code that will search through the column A and if the text in the column is "First Line" for example then it should delete the row. 
|
|
#2
11-19-2013, 01:38 AM
|
||||
|
||||
|
Hi
you are in the wrong forum - Please ask admin or mod to move it to the programming forum
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
| Tags |
| macro, select |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro for select words?
|
Megan Sprack | Word | 1 | 08-23-2012 03:03 PM |
|
Macro to select tables
|
ubns | Word VBA | 5 | 04-15-2012 11:44 PM |
|
Can't select shapes via macro
|
TishyMouse | Word VBA | 3 | 04-13-2012 03:26 AM |
|
Select statement to a new document
|
ishaw | Word | 1 | 10-17-2011 02:23 AM |
| Select Series Color - Macro | judicial85 | Excel Programming | 0 | 03-14-2011 02:35 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode