Macro to be there in single Button.

[shekar goud]

Hi Team,

I have a macro which was developed with the help of our Experts.

I need all that macros to be in 1 button would that be possible.

I have tried this but not able to make it.

Any Help is Greatly Appreciated.

Please Login or Register  to view this content.

Thanks & Regards,
Shekar Goud.

[mudraker]

Have the macro attached to the button call the other macro's

Please Login or Register  to view this content.

[shekar goud]

Hi Mudraker,

Thanks for your intrest I have tried this but unforunate not succeded.

Please Login or Register  to view this content.

Regards,
Shekar.

[shekar goud]

Hi Team,


Any Luck on the above.


Regards,
Shekar.

[Andy Pope]

pretty though the picture is it does not provide us with the information to resolve your problem.

Which routine fails?
What line in that routine fails?

If you manually run each macro 1 after the other do you still get the error msg?

[shekar goud]

Hi Andy,

When i Run Manullay each macro works very well but when i called the macros in one then i encounter with this kind of error in evry macro.

Is there any possiblity of resolving please suggest.

Iam just an begginer in VBA.


Regards,
Shekar.

[Andy Pope]

probably but you didn't answer all the questions.

where exactly does the error occur?

you could try setting the TakeFocusOnClick property of the button to False

Can you post workbook example

[shekar goud]

Hi Andy,

Thanks for all your Support.

I did something to get the solution and that is working fine.

In the code after Every End With i need an code which can copy the active column to next left column.

Now i Need is Copy the active column and paste it to next left column.I have tried this but getting an error.

Please Login or Register  to view this content.

Iam attaching the pic of both error and when i tried to put the same in code.

Please kindly help me.


Regards,
Shekar.

[shekar goud]

Hi Team,

I have struggling to reslove this could someone please give a solution.

iam Attaching an excel sheet.

1) In Column J(can be moved to i,J,K) i need the total of "Wright" iam adding the code aslo.

2) In Column K(can be sometimes moved to J,K,L,M)i need the total of "Shekar" iam adding the code too.

3)And finally I need all this in One Click Button.

Please Kindly help me .

Please Login or Register  to view this content.

Regards,
Shekar.

[Andy Pope]

Assuming your routines all work this runnings without error.

[shekar goud]

Brilliant since 4 days iam struggling for this Hats off to you.

But still My Button dream remains same.


Once Again thanks to you Andy.

Regards,
Shekar.

[Andy Pope]

What button dream? Did you not try the one on the sheet by cell U13 ?

[shekar goud]

Ohhhh really excellent.iam sorry i did'nt watched it.

Really great thanks for all your help Andy.

Regards,
Shekar.