Microsoft Office Forums

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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Is this a one shot task?
I would also advise using a more descriptive thread title. The search engines will be more helpful
__________________
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
  #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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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
__________________
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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 AM.


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