Excel f(x)s = Excel Functions
BoldCodes is here to help (BoldCodes.com or Bold.Codes), even though I doubt it, I mean the fact that you cannot do your task in Excel formulas. especially after you understand 25% of these formulas.
But when you do, check out the library of VBA/Excel (aka macros, aka vbscripts) programming codes at BoldCodes.com or Bold.Codes
Worksheet and workbook specifications and limits For more limits of VBA inside Excel, check out http://BoldCodes.com/?DevID=26CFPFO4LB Feature Maximum limit Open workbooks Limited by available memory and system resources Worksheet size 1,048,576 rows by 16,384 columns Column width 255 characters Row height 409 points Page breaks 1,026 horizontal and vertical Total number of characters that a…
This is what happens when you spend too much time in Excel
Go have a break and get some life
Working a lot with Excel means seeing lots of errors and bugs inside Excel
Some of those are not likely bugs, but more like reaching the limit of the application.
One of the settings that I always change when I first get a new Excel installation is …
Remove “Edit directly in cell”
Here is where you find that option
Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on that particular single input (or more)
So, i learned a trick, it is formatting the entire sheet to certain color and give that cell special format to make it look like a textbox.
Starting Excel 2007, users are not getting easy access to developer stuff.
Not sure why is that, but we can go around that, so quickly, if you need to start developing inside Excel (using VBA) first thing to do is to show the “Developer” tab that came in hidden by default
Just follow on these steps
Excel 2010 was great because you can easily open another Excel session while your current session is working.
This allowed us to run multiple tools at the same time, since those two sessions are separated and do not touch.
However, starting Excel 2013, the interface changed, making it harder to run new session or open Excel while we have another Excel session running some long process.
