Microsoft Office Forums How to write VBA in following example

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 12-05-2017, 04:56 AM
yoyo4 yoyo4 is offline How to write VBA in following example Windows 10 How to write VBA in following example Office 2013
Novice
How to write VBA in following example
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default How to write VBA in following example

Hi all,

Need to automatically delete row that contain certain keywords.(keywords-loan,financial,bank,equity)



i have data sheet with 5 column.(Name,Last Name,Company Position,Email Address Phone Numbers )If any of above keywords are located in any cell (as part of a word, email, address, job title, company, etc,) need to delete the row automatically.
  #2  
Old 12-05-2017, 10:06 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to write VBA in following example Windows 7 64bit How to write VBA in following example Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Is this a one shot task?
I would also advise using a more descriptive thread title. The search engines will be more helpful
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
  #3  
Old 12-05-2017, 10:41 AM
yoyo4 yoyo4 is offline How to write VBA in following example Windows 10 How to write VBA in following example Office 2013
Novice
How to write VBA in following example
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default

Hi,
im search that 'Automatically delete row based on keyword' topic
but couldn't find answer.
  #4  
Old 12-06-2017, 12:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to write VBA in following example Windows 7 64bit How to write VBA in following example Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

I meant that a descriptive thread title will draw more attention to your question on the Net.
You did not have to create a new thread, just change the title of this one.
I will close this one now
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Closed Thread

Tags
excel 2013, excel vba, visual basic

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to write macro yoyo4 Excel Programming 1 11-19-2017 11:43 PM
How can I write if condition to get the values ... LearnerExcel Excel 3 12-15-2016 03:10 AM
write need help and copy write need help on another page auto wykoems Word 2 07-25-2013 07:56 AM
How do you write a macro with an IF Function Scheuerman1987 Excel 5 06-05-2013 06:04 AM
How to write VBA in following example Write Test dkub Word VBA 1 07-21-2012 09:01 PM


All times are GMT -7. The time now is 05:08 PM.


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