What does the statement do? - ProProfs Discuss
Advertisement

What does the statement do?

Application.Worksheets("Data").Range("1:10").EntireRow.Delete

Asked by Anmol, Last updated: Apr 12, 2024

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

E. Barnes

E. Barnes

But Can you play this?

E. Barnes
E. Barnes, Professional Gamer, Professional Gamer, Washington

Answered May 02, 2019

The correct answer to this question isDeletes Entire Rows from 1 to10 in the worksheet Data. This action would occur in Microsoft Excel. The code used to delete the rows is a visual basic application. These applications, also known as VBAs, allows a command to be implemented with a single button.

To start a VBA, the Developer tab needs to be added to the ribbon in Microsoft Excel. It is then vital to know how to modify cells, which is how the command can be established. Creating sheets are also important because they help seperate the large amounts of data.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Jul 30, 2017

Deletes Entire Rows from 1 to10 in the worksheet "Data"
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.