Avatar of Peter Chan
Peter Chan
Flag for Hong Kong asked on

Problem to delete range

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?
VB ScriptVBAVisual Basic ClassicMicrosoft ExcelMicrosoft Applications

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon
Guy Hengel [angelIII / a3]

what type is range0?
Peter Chan

ASKER
It is
Dim Range0 As String

Open in new window

ASKER CERTIFIED SOLUTION
Guy Hengel [angelIII / a3]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Roy Cox

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!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy