answersLogoWhite

0

How do you delete rows with a specific words using macro?

Updated: 8/20/2019
User Avatar

Wiki User

10y ago

Best Answer

If, for example, you wish to delete rows 4 through 6...

Range("A4:A6").Select

Selection.EntireRow.Delete The easiest way to learn how to do something from a Macro that can also be done manually is to click Record Macro (it doesn't matter what you name it), perform the task manually, click Stop Recording, click Macros and select the Macro that was just created, click Edit, and look at the commands that were generated by the program.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you delete rows with a specific words using macro?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are words ending in macro?

There are no words that end with macro, but there are a few words that begin with those letters.MacrobioticMacrocosmMacrologyMacronMacrons


What are 5 words describing a major scale?

macro


What is part of the interviewing process?

using a lot of industry-specific words


How do you delete your Words With Friends account?

You can't delete them.


How do you delete words with friends accounts?

You can't delete them.


You cannot leave blank lines between macros in a macro group?

This is not a question; it is a statement. Please ask a question using words that indicate what you would like to know.


What are two words an Excel macro ends with?

End Sub.


What do you mean by macro and micro environment of business and economy?

In simple words micro macro economics can be explained as- " What holds good for micro economics may not hold good for macro economics' Eg: Savings.


What does rhetoric over substance mean?

Rhetoric means using words to convince or persuade; rhetoric over substance means using words instead of evidence. The evidence could also be words but they would be words with specific information as opposed to words of opinion or suggestion.


What is macro ecosystem?

A macro ecosystem can be described as a single biological community of interacting living things and their physical environment that expands automatically into a set of communities. This term is form by the two words, macro and ecosystem.


When you delete the contents of a cell you also delete the cells format?

If you delete just the contents of a cell, then its formatting will stay. Then next time you put something into the cell, it will use that format.


What are words ending with LETE?

obsolete, delete,