answersLogoWhite

0

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

11y ago

What else can I help you with?

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


Can you use underscores in a macro name?

Yes, you can use underscores in a macro name. Many programming languages and macro systems allow underscores as valid characters in identifiers, which include macro names. However, it's important to check the specific syntax rules of the language or environment you're working in, as conventions may vary. Using underscores can help improve readability by separating words in the name.


What are 5 words describing a major scale?

macro


How do you delete words with friends accounts?

You can't delete them.


How do you delete your Words With Friends account?

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 is part of the interviewing process?

using a lot of industry-specific words


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,


What are the four macro language skills?

The four macro language skills are listening, speaking, reading, and writing. Listening involves understanding spoken language, speaking involves using words to communicate orally, reading involves understanding written language, and writing involves producing written language.