Solved

Problem to delete range

Posted on 2016-07-26
4
54 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 17

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now