Help me please
- Thread starter bloubul
- Start date
time*treat
Member
time*treat
Where in the macro must I change to take only 6 columns and not 7. The powerballs are 5 nrs and the power-number, I can see where I must change the max values.
BlouBul
Have you tried changing
Public Const Digit__Count As Long = 7
to
Public Const Digit__Count As Long = 6
over the routine called Summary__Reset?
I can't say for certain how it will handle cases where the bonus number matches one of the main numbers, since checking for in-set repeats wasn't part of the orig design.
Frank
Member
Hi All
I'm in search a macro to mark colored numbers accordingly.
Attached are the spreadsheet with a markup of what the macro must do. Please read the "Notes", for the instructions.
https://www.mediafire.com/file/e6fueq4o3c3d5qo/Trails.xlsx/file
Thanks
BlouBul
Just to let you know that mediafire is playing up again. Your file is not available.
Download not available
This file can not be downloaded because there was a problem with the upload. If possible, contact the person uploading the file to ask them to upload it again.
Frank
Member
Frank
I'm also struggle to login.
I will see what I can do, otherwise I'll send it to your mail.
BlouBul
Well I only wanted to look at the file because it looked like a conditional formatting problem from your description "I'm in search a macro to mark colored numbers accordingly".
Having seen the file, it is nothing of the kind. you appear to be wanting columns inserting under certain unspecified conditions, "........... but I must be able to select the rows, from 6 to 29 rows. (under what conditions, when ?).
Its just not a problem I want to figure out or get involved with, personally I think more explanation ise required, so I'll upload it for you and hope someone else has time and inclination to deal with this. Perhaps time*treat might like this one?
https://www.mediafire.com/file/1piwrcy7tc5v751/trails.xlsx/file
bloubul
Member
Frank
At least MediaFire fires again.
"I must be able to select the rows, from 6 to 29 rows". Yes that is the condition..............
Nr's Drawn Pool Size Draws Needed
5 19 6
5 20 6
5 25 8
5 26 8
5 28 9
5 30 9
5 31 10
5 32 10
5 33 10
5 34 11
5 35 11
5 36 11
5 37 12
5 38 12
5 39 12
5 40 13
5 41 13
5 42 13
5 43 14
5 44 14
5 45 14
5 47 15
5 49 15
5 50 16
5 52 16
5 53 17
5 54 17
5 55 17
5 56 18
5 59 19
5 80 25
5 90 29
6 25 7
6 30 9
6 32 9
6 33 9
6 34 10
6 35 10
6 36 10
6 37 11
6 38 11
6 39 11
6 40 12
6 41 12
6 42 12
6 43 12
6 44 13
6 45 13
6 46 13
6 47 14
6 48 14
6 49 14
6 50 15
6 51 15
6 52 15
6 53 15
6 54 16
6 55 16
6 56 16
6 58 17
6 59 17
6 60 18
6 63 18
6 69 20
6 90 26
You are welcome to disagree with me. As I have said before, the macro must just insert the blank columns as indicated, mark it accordingly and make a summary.
If it cannot be done tell me, than I must do it MANUALLY, which will take more time and as a Human I may miss some crucial numbers as I only have one "EYE" to look with, but I'm up to it.
I only tried to make it easier on my eyes.
BlouBul
At least MediaFire fires again.
"I must be able to select the rows, from 6 to 29 rows". Yes that is the condition..............
Nr's Drawn Pool Size Draws Needed
5 19 6
5 20 6
5 25 8
5 26 8
5 28 9
5 30 9
5 31 10
5 32 10
5 33 10
5 34 11
5 35 11
5 36 11
5 37 12
5 38 12
5 39 12
5 40 13
5 41 13
5 42 13
5 43 14
5 44 14
5 45 14
5 47 15
5 49 15
5 50 16
5 52 16
5 53 17
5 54 17
5 55 17
5 56 18
5 59 19
5 80 25
5 90 29
6 25 7
6 30 9
6 32 9
6 33 9
6 34 10
6 35 10
6 36 10
6 37 11
6 38 11
6 39 11
6 40 12
6 41 12
6 42 12
6 43 12
6 44 13
6 45 13
6 46 13
6 47 14
6 48 14
6 49 14
6 50 15
6 51 15
6 52 15
6 53 15
6 54 16
6 55 16
6 56 16
6 58 17
6 59 17
6 60 18
6 63 18
6 69 20
6 90 26
You are welcome to disagree with me. As I have said before, the macro must just insert the blank columns as indicated, mark it accordingly and make a summary.
If it cannot be done tell me, than I must do it MANUALLY, which will take more time and as a Human I may miss some crucial numbers as I only have one "EYE" to look with, but I'm up to it.
I only tried to make it easier on my eyes.
BlouBul
time*treat
Member
Looked this over a few times.(snip)
You are welcome to disagree with me. As I have said before, the macro must just insert the blank columns as indicated, mark it accordingly and make a summary.
If it cannot be done tell me, than I must do it MANUALLY, which will take more time and as a Human I may miss some crucial numbers as I only have one "EYE" to look with, but I'm up to it.
I only tried to make it easier on my eyes.
BlouBul
These things can all be done with macros.
The page formatting (vertical line color) on Trails5 is different than on Trails6. If that's how you intended it, you'll need two page formatting macros. Anyway, use the 'Record Macro' button and insert the columns you want, and do all the other color and border formatting and you'll have the code template needed. You'll need to edit this to hook in the 6-to-29-row variable.
Some other decisions have to be made, too (for example, is the x assigned by checking the dated numbers row, checking against an array holding the same values, or just checking the correct number of boxes to the left, for a blue cell. Any of those can be used but none is specified. If you're going to base it on the dated numbers row, you'll have to account for that row jumping around based on whatever number (6 to 29) of rows you're using -- presuming the output won't always be on rows 16 and 14, respectively.
If the subheaders are all generated at once, then this is different than if each is generated with its own trial data.
The summary is just another array, with a counter attached.
Again, these can all be done with macros, but layout and how you hook it in to the main code matters.