mrkeck Sharing the Love


Handy Excel VBA settings

'Turn Off AutoCalc -- speeds up copying and pasting until you are finished
Application.Calculation = xlCalculationManual
'Stops the screen from flashing while it is working
Application.ScreenUpdating = False
'Return excel to normal flashing while doing stuff
Application.ScreenUpdating = True
'Turn On AutoCalc
Application.Calculation = xlCalculationAutomatic
Filed under: Excel No Comments

Excel Wrap Text align left

I was having an issue with Wrap Text. Every time it would center to the middle of the text. I wanted it to start with the beginning but not run into other cells.

To do it set the horizontal alignment to "Left" or "General" and the vertical alignment to "Top" and, obviously, turn on Wrap Text.

You will need to adjust the row height as well to keep the spacing regular.

Filed under: Excel No Comments

PHP file_get_contents timing out even with set_time_limit

It turns out that file_get_contents looks at max_input_time. So I changed max_input_time=180 in php.ini and set set_time_limit(0) in the page I was working on. All good now.

Filed under: PHP No Comments

PSD Thumbnails

The best (free) way to have .psd thumbnails show in explorer ( or clover) is to install this program called sage thumbs:

Filed under: Photoshop No Comments