Newton Excel Bach is aimed at people who work with numbers without a $ on the front. Posts will alternate between Excel and engineering/science topics, with the occasional post related to neither when I feel like it.
It is written by Doug Jenkins, chief cook and bottle washer at Interactive Design Services, a Sydney based structural design consultancy specialising in the analysis, design and review of bridges, buried structures, retaining walls and related civil engineering structures. More details may be found at: Interactive Design Services
A good day ; I want to say that what is here is the produce of a shinely mind .
I have a very big need of your help ! … I try to get
the solution for an UDF which work in array ; how can I contact you , if you allow me ?
Please very much for help , I have a very big need to have this UDF , and it seems nobody can give me the right solution anymore ;
I put here a link where is described all my problem :
http://groups.google.ro/group/microsoft.public.excel.programming/browse_thread/thread/b87e18a67d2676f/c41b3aeaa334974e?hl=ro&lnk=gst&q=UDF#c41b3aeaa334974e
The thread have name UDF …VBA Formula built …please help , username ytayta555 ;
Thank you very much , and I wait impatient your big help for me .
Respectfully
Dombi – thanks for your comments.
I have left a reply in the thead you linked to.
I didn’t expect to get response from a great personality like you , mr. Doug Jankins , I’m
really surprised . Great atitude …
Now , my problem is solved 98% ; I hope
and please you to help me and to resolve the
last part of 2% . Really , I just wonder what can
I do to can do for you what you just done
fore me .
What a benefit for humanity to have so shinely
and creative minds …
Hi
First of all, thanks for putting this info on, and sharing it.
It is of great quality.
Second, I would like help on using intersection, maybe you could spare me some time, if you can give me a brief overview of the module.
I am a soccer coach, and I’m trying to make some tools in office to analyze the Systems of play, to calculate the number of lines of passes for example, and for that I would need to use an intersection functionality, don’t need to know where is the intersection exactly, but to know how many there are.
Third I made code to calculate the length of a line, and an absolute angle in 0-360 using only left, top, width and height.
For what I can see on your blog mycode is really humble, but if you think that is useful for you or anyone else I would share it gladly.
Hi João – I’m not exactly sure how your line of passes system would work at the moment, but if you would like to send some sketches and/or worksheets to my Gmail account (Dougaj4 at the usual gmail) I will have a look at them when I have time (pretty busy at the moment, so it may not be straight away). I’d be interested to see your line length code as well if you would like to send it.
Thanks for the kind comments.
Doug
Dear Mr Jenkins,
We identified your site as one of the leading information sources on the Internet about Microsoft Excel software. We would like to take this opportunity to introduce you our site, SpreadsheetZONE.
SpreadsheetZONE, a content partner of Microsoft Office Online, is a growing repository of free online Microsoft Excel templates available for everyone for personal or business usage. Most of the templates are developed by SpreadsheetZONE Team, in various categories including finance, sales, education, and project management. Our library grows everyday as new templates are published, and number of our users keeps increasing.
Please visit our site at http://www.spreadsheetzone.com and let us know what you think. We always welcome suggestions from Excel community to improve our site and services.
Thank you,
SpreadsheetZONE Team