Almost a Technocrat in Draft

A list of secret codes to access various Nokia phones' information which are not presented in the menu. *#06# Displays the EMEI, the serial number of the mobile phone. *#0000# Displays the current installed firmware's information. *#2820# (*#bta_#) Displays the Bluetooth address of the mobile phone. *#62209526# (*#mac_wlan#)  Displays the Wireless LAN's mac address of the mobile phone. *#7780# (*#rst_#) Soft reset the mobile phone. Restores settings to factory default settings but does not remove installed applications and games on the mobile phone.   *#7370# (*#res_#) Hard reset the mobile phone. Restores settings to factory default settings and remove all install applications and games in the mobile phone. *#3370# Enhanced Full Rate Codec (EFR) activation. Enhanced Full Rate increase the voice quality of phone calls with the expense of about 5% more energy compare to Full Rate codec. *#3370* (EFR) deactivation. *#4720# Half Rate Codec activation. Half Rate codec will

Sometimes, a verbose boot process is needed for debugging purposes. In order to see that, the splash screen need to be disabled. Following steps are for Grub2 which is used from Karmic Koala onwards. Open /etc/default/grub and edit: sudo vi /etc/default/grub Locate line that says: GRUB_CMDLINE_LINUX_DEFAULT="quiet splash" Remove "quiet" and "splash". The new line will look like: GRUB_CMDLINE_LINUX_DEFAULT="" Save and exit. Update the grub: sudo update-grub Note: To get the splash and the boot process messages, just remove "quiet". References https://help.ubuntu.com/community/Grub2

@echo off&SETLOCAL FOR /f "tokens=1-4 delims=/-. " %%G IN ('date /t') DO (call :FIXDATE %%G %%H %%I %%J) goto :SETDATE :FIXDATE if "%1:~0,1%" GTR "9" shift FOR /f "skip=1 tokens=2-4 delims=(-)" %%G IN ('echo.^|date') DO (     set %%G=%1&set %%H=%2&set %%I=%3) goto :eof :SETDATE ENDLOCAL&SET mm=%mm%&SET dd=%dd%&SET yy=%yy%

Non Macro Solution Select the first cell that have the content that need to be paste to the empty cells. Scroll down to the last empty cells below the first cell that needed to be fill. Hold shift and select the last cell. Ctrl + D Macro Solution Sub fill_cells()     Selection.SpecialCells(xlCellTypeBlanks).Select     Selection.FormulaR1C1 = "=R[-1]C"     Range(Cells(1, 1), Selection.SpecialCells(xlCellTypeLastCell)).Select     Selection.Copy     Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False End Sub References: My Excel Pages -- David McRitchie (Fill The Empty Cells)