Another milestone reached. I suspect the next 100k won't take so long.
Thanks to everyone here who help make this site such a friendly place.
Another milestone reached. I suspect the next 100k won't take so long.
Thanks to everyone here who help make this site such a friendly place.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Perhaps if you take the next twenty years off, we might catch up. Mighty fine effort that's all I can say.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
And you've done over 5% of them . That's a lot of questionsOriginally Posted by mdmackillop
Good stuff!
As a lot of ppl just get their answers from trawling sites and the net and not posting any questions of their own, it would be interesting to see what the total 'View' count to date was also - is that stat available?
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Total Unique Views Per Thread = 2,492,664
Total Threads = 12,603
Total Posts = 100,933
Average Posts Per Thread = 8
Average Views Per Thread = 198
So approximately 190 unique people on average view a thread and don't post.
That's only "true" if people view the thread once. The real figure would be somewhat less. I know from experience that I sometimes re read a thread that I might be interersted in.
Sometimes I'm not actually looking for an answer but just in following a particular persons line of attack or defence regarding an issue.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link