need help with VBA and Macro on sheet

Find a developer for your Excel triggered betting needs and advertise your development service here.

Moderator: 2020vision

need help with VBA and Macro on sheet

Postby samhayer » Tue Jun 11, 2024 12:43 pm

Hi everyone I hope all are well, I need some help with this sheet I have been working on, I am no expert with VBA and Macros just trying learn as I go long. I would like to thank all and every one who read this and are able to help me in any way . So I have been working on a Sheet which is now working to some extent but has still got a few thing to sort out before the job is good . I will try and address one problem at a time and hope to fix these and have a working sheet and learn some VBA . Ok so In my market sheet (Sheet1) I have put this VBA code in the Worksheet. j

Private Sub Worksheet_Calculate()
If Sheet1.Cells(5, 37) = 1 Then

CopyAI5


End If

End Sub
so what this does is if Row 5 and Colum 37 is equal to 1 a macro called CopyAI5 willcopy and past the value from AI5 toAG5 this is all working fine
Now I want to add to this worksheet If Row 6 and Colum 37 is equal to1 then a Macro called CopyAI6 will Run.And 1 would like continue to add another 13 Makros up to
If Sheet.Cell(20, 37)=1 Then CopyAI20

I have tried putting different codes in but none work. Please can some one advise me on this or if a developer can help I have a few other things need to be looked at also thankyou all. Best Regards. Sam Hayer
samhayer
 
Posts: 66
Joined: Wed Apr 11, 2012 4:57 am

Re: need help with VBA and Macro on sheet

Postby doris_day » Sun Sep 29, 2024 8:06 am

Try asking chatGPT. It's pretty good for solving coding issues, particularly if you're a paid subscriber and use o1-preview
'He was looking for the card so high and wild he'd never need to deal another' - Leonard Cohen
User avatar
doris_day
 
Posts: 968
Joined: Fri Nov 02, 2007 12:34 am


Return to Find an Excel developer

Who is online

Users browsing this forum: No registered users and 6 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.