This question arose out of curiosity. Another discussion on StackOverflow led me to this question. Reference to this discussion can be found here:
This applies to users who have not changed...
If you search following term on Google:
"Who created Excel" or "Who invented Excel" then Google promptly returns Dan Bricklin's name and couple of his younger day photos.
In reality, Dan Bricklin never worked for Microsoft. But he did create the electronic spreadsheet before Microsoft Excel...
I have been working on a code for my friend to pull information from website (financial). Putting code together was not an issue.
It is two phased approach:
1. It pulls portfolio information from listed mutual funds.
2. Then it scrapes individual share prices from the same site...
While writing VBA codes it is not uncommon to come across a situation where your worksheet formula needs to be implemented through VBA code. Typing quotes can be headache and sometimes irritating with longer formulas. Of course, you can use macro recorder but it will copy the formula in R1C1...
While sifting through my old codes, I found these three animations I had created. I had created those after seeing some online examples of Microsoft excel templates. They are basic and not so heavily tested.
1. Fill my glass - fills a glass kept on table... ;)
2. Flames - these are industrial...
I was going through some time stamps options shown up on the internet including the one posted by Chandoo. Mostly they seem to use iterations to create time stamp.
In MS Help for CELL function I read that it checks information for the last changed cell if the optional reference is kept empty...
Hearty Congratulations, Somendra on your first milestone. You've been quite prolific. Keep up the good work.
BTW, wonder where Sajan is these days. I have not seen his formula spins for quite some time now.
Post upgrading forums, I have seen couple of things [maybe they are already noticed and being fixed] that have been affected little.
In old forums we posted codes with backticks (`) and those codes post migration have got some unusual guests in between. See this example...
I think this is easier one but saw this as requirement on some other forum. The person had requested a VBA solution as probably he thought VBA was easier [only?] route.
Here is the data:
Heading Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 CC
H1 12 0 0 0 0 -5 1...
Wishing you all a happy and prosperous new year.
I've tried to cobble something for you guys in Excel which can be done trivially in powerpoint.
I hope you all like it:
One (two) of my post to dsudhakar's question in "Ask an excel question" section regarding weekdays is stuck. Kindly resolve the issue. You can delete 2nd post of mine no problem.
Sometimes we need to bring a specific window to front (activate) but we do not know its complete name. Following API based code can do that. The usage of module can be changed by the user after understanding the code. Feel free to do so.
PS: I've kept this as KB entry (For Approval) on VBAX...