Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












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



See all Topics

Labels: ,


<Doug Klippert@ 3:12 AM

Comments: Post a Comment