Posts

Showing posts from December, 2011

Excel disable auto increment in formula by row and column

=CONCATENATE(J29,$H29,"mmm") If you want to copy across, but always refer to H29. =CONCATENATE(J29,H$29,"mmm") If you want to copy down, but always refer to H29. =CONCATENATE(J29,$H$29,"mmm")If you want to copy down and across, but always refer to H29. $h29 -> places dollar before column disables auto increment in column h$29 -> places dollar before row disables auto increment in row $h$29 -> places dollar before row and column disables auto increment in row & column. Was very hard to find out that. src  http://forums.techarena.in/windows-software/1181179.htm

Virtuemart fetchscript off

$_REQUEST['usefetchscript'] = "0"; /administrator/components/com_virtuemart/virtuemart.cfg.php http://www.joomlahackers.net/virtuemart-tutorials/how-to-switch-off-fetchscript-in-virtuemart.html

Enable IP range in IPTABLES

iptables -A INPUT -p tcp --destination-port 22 -m iprange --src-range 192.168.1.100-192.168.1.200 -j ACCEPT http://www.cyberciti.biz/tips/linux-iptables-how-to-specify-a-range-of-ip-addresses-or-ports.html