When to use Range.value and Range.formula


Cell A3 has the sum function in it.

When writing excel VBA code you can choose what do you need to return the value or the function inside the cell.

Use Value to see a result of 30
Use Formula to see the text in the cell

Use Excels VBA immediate window to show you what it will return as your answer.
Ctrl G will bring up the immediate window.

excelexcel immediate window

for more tips visit http://www.azsolutions.com.au

Advertisements

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s