Excel VB Script for Rearrenging the Columns in sheet

[naveenkumarsjce]

Please Login or Register  to view this content.

[naveenkumarsjce]

Please give your Feedback if you see shorter script than this

[AB33]

We can not see it untill you attach your sample in excel book.

[HaHoBe]

Hi, naveenkumarsjce,

a litlle bit of overkill to my taste:

Please Login or Register  to view this content.

And I won´t really use a function for that but rather a procedure. There should be any kind of feedback if the function did fulfill what it was about to do.

@AB33

We can not see it untill you attach your sample in excel book.

I do not agree as this function can only be called from inside a VBA code.

Ciao,
Holger

[AB33]

Hi Holger ,
Whether it is a sub or a function, or calling a function from anywhere I could not give a feeback by just looking at the code.
You can, that is your choice.

[naveenkumarsjce]

Or you can try with code just copy paste to any sheet to see if it works or not

[naveenkumarsjce]

Thanks, Can you provide me the link for using these kind of instructions. as i am new for Excel script but i know VB6.0 Coding

[HaHoBe]

Hi, naveenkumarsjce,

could you please be a bit more precise on

these kind of instructions

Arrays, Loops, Functions, Subs?

Ciao,
Holger

[naveenkumarsjce]

function as you can see in code itself

[HaHoBe]

Hi, naveenkumarsjce,

Macros And Functions, Writing Your Own Functions In VBA and VBA Functions along with the VBA-Help and the Object Browser in the VBE (F2) should deliver a start.

Ciao,
Holger