Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-19-2013, 01:11 AM
Nicolette Nicolette is offline select statement in macro Windows 7 64bit select statement in macro Office 2010 64bit
Novice
select statement in macro
 
Join Date: Nov 2013
Posts: 1
Nicolette is on a distinguished road
Default 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.
Reply With Quote
 

Tags
macro, select



Similar Threads
Thread Thread Starter Forum Replies Last Post
select statement in macro Macro for select words? Megan Sprack Word 1 08-23-2012 03:03 PM
select statement in macro Macro to select tables ubns Word VBA 5 04-15-2012 11:44 PM
select statement in macro Can't select shapes via macro TishyMouse Word VBA 3 04-13-2012 03:26 AM
select statement in macro 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft