Problem to delete range

HuaMin Chen
HuaMin Chen used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
what type is range0?
HuaMin ChenProblem resolver

Author

Commented:
It is
Dim Range0 As String

Open in new window

Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
is the workbook or some parts of it protected?
what is the adress value of usedrange?
Roy CoxGroup Finance Manager

Commented:
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial