Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, November 25, 2008 – Permalink –

Information Functions

Who, What, Where


If you need to know if automatic calculation is on or off or the number of worksheets that are active, Excel can display the INFO.



System Information:

Current directory
=INFO("directory")

Available bytes of memory
=INFO("memavail")

Memory in use
=INFO("memused")

Total bytes of memory
=INFO("totmem")

Number of active worksheets
=INFO("numfile")

Cell currently in the top left of the window
=INFO("origin")

Operating system
=INFO("osversion")

Recalculation mode
=INFO("recalc")

Excel version
=INFO("release")

Name of system. (PC or Mac)
=INFO("system")


More:

Excel-VBA.com:
Excel Spreadsheet Information Functions


[Edited entry from 9/8/2005]



See all Topics

Labels:


<Doug Klippert@ 3:09 AM

Comments: Post a Comment

Links to this post:

Create a Link