Solved

Problem to delete range

Posted on 2016-07-26
4
72 Views
Last Modified: 2016-07-26
Hi,
I get
5l.pngdue to
            Range(Range0).EntireRow.Delete

Open in new window


while Range0 is having
$2:$2

Open in new window


inside. Why?
0
Comment
Question by:HuaMinChen
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 41728948
what type is range0?
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41728955
It is
Dim Range0 As String

Open in new window

0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 41728959
is the workbook or some parts of it protected?
what is the adress value of usedrange?
0
 
LVL 18

Expert Comment

by:Roy_Cox
ID: 41729854
I have posted several times in response to questions from you which have the same problem but you still keep making the same errors. I also pointed out about using UserInterface only to avoid this. Also, it would be nice if you took the time to actually complete the question I helped you with about the Ribbon!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

776 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