showing error at Selection.Delete Shift:=xlToLeft

[anilg0001]

Please Login or Register  to view this content.

error shows object required
any one help?

[HaHoBe]

Hi, anilg0001,

if you want to get into serious programming get away from both using ActiveCell as well as doing unnecessary Selects.

What do you want to get from the second loop with the variable i as it is not used in your code?

Please Login or Register  to view this content.

Ciao,
Holger