Excel VBA - Value vs Text


Value vs Text


Sheets(1).Cells(6, 3).Value will give the raw value in the cell.

Sheets(1).Cells(6, 3).Text will give what you see in the cell.

Comments

Post a Comment

Popular posts from this blog

Redhat / CentOS / Fedora Linux Open port using ip table

Image
By default iptables firewall stores its configuration at /etc/sysconfig/iptables file. You need to edit this file and add rules to open port number. This file only avilable under Red Hat Enterprise Linux 3 / 4 / 5 and above => Old Red hat Linux version => CentOS 4 and above => Fedora Linux We will use port 80 as example. Open port 80 Open flle /etc/sysconfig/iptables: # vi /etc/sysconfig/iptables Append rule as follows: -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT Save and close the file. Restart iptables: # /etc/init.d/iptables restart Restart iptables service Type the following command: # service iptables restart Verify that port is open Run following command: netstat -tulpn | less Make sure iptables is allowing port 80 connections: iptables -L -n Refer to iptables man page for more information about iptables usage and syntax: man iptables Referenced from : http://www.cyberciti.biz/faq/howto-rhel-linux-open-port-using-iptables/
Read more

Install zeromq on Yosemite with php PECL

brew install zeromq Building php extension via PEAR sudo pecl install zmq-beta You will have to add the extension to your php.ini with this line: extension=zmq.so Find the php.ini File Location from the Command Line php -i | grep php.ini You can, of course, always put a new php file in your web server root directory and add in the following: phpinfo();
Read more

Druid: The Database Manager

Image
The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information. Once the database is created, the druid can generate: HTML documentation: for all tables, with browsing facilities PDF documentation: for all tables Java classes: (one class for each table) that contain tables' constants (such as fields size) plus java code added by the user A data dictionary that contains all tables and fields present in the database SQL script which contains all table definitions that can be piped to the DBMS http://druid.sourceforge.net/
Read more