SolvedPrivate

VBA: Best way to clear contents for multiple columns starting with 2nd row, and all the way down

Posted on 2015-02-23
3
21 Views
Last Modified: 2016-02-10
What's the most efficient way to write the code to clear contents for multiple columns, let's say A through D, starting with 2nd row, and all the way down? Thanks
0
Comment
Question by:Dmitriy Kritskiy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 15

Expert Comment

by:gplana
ID: 40626568
I think best way is:

Sheets("Test").Rows("2:65535").Delete
0
 
LVL 10

Accepted Solution

by:
Anthony Berenguel earned 500 total points
ID: 40626574
Try
    Application.Goto Reference:="R2C1:R2C4" 'where R is row and C is column. 
    Range(Selection, Selection.End(xlDown)).Select
    Selection.ClearContents

Open in new window

0
 

Author Closing Comment

by:Dmitriy Kritskiy
ID: 40626598
Perfect!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question