Move column - Used Find function

[Pawnar]

Hello sir/ma'am,

I need to cut the column I [0-15] and paste it to column b by inserting a new column.

I tried with:

columns("i").cut
columns("b").insert

But, the agebucket column "0-15" keeps changes on daily basis depending on received ageing. I also tried with find function, but it is giving me an error:

Range("b2:b7").Find(what:="0-15", MatchCase:=True, lookat:=xlWhole).Select

Please help

Regards,
Manish

[PCI]

Is it what you need ?

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[Pawnar]

Yes sir, That is worked like a charm - @ PCI

[Pawnar]

thank you sir - this is what I wanted - @Jindon

[PCI]

You're welcome and thx for the Rep