We help IT Professionals succeed at work.

Problem to delete range

134 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?
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
what type is range0?
Peter ChanProblem resolver

Author

Commented:
It is
Dim Range0 As String

Open in new window

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

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!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.