SpreadCE / Spread32 Forum Index SpreadCE / Spread32
Hosted by freeforums.org
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups    RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Welcome
Welcome to SpreadCE / Spread32.

You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, join our community today!

Exclamation mark symbol ( ! )

 
Post new topic   Reply to topic    SpreadCE / Spread32 Forum Index -> General
View previous topic :: View next topic  
Author Message
thinman



Joined: 13 Jun 2008
Posts: 8

PostPosted: Mon Jun 23, 2008 11:17 pm    Post subject: Exclamation mark symbol ( ! ) Reply with quote

Stephen.....

Noticed the above symbol in some of your macro examples which
you provided in the forum. Did a Google search and found plenty
of Excel tutorial sites and while some showed the symbol, none
described its' purpose.

So, what does it do/represent/enable ??

I would like to get an Excel instructional book to better understand
how to work with this program. Any suggestions for a particular
author/title ? I used to work with Lotus 123 (v 2.1a) and am
familiar with a lot of the concepts; it's just the command names are
all new. Need examples to help me wrap my head around this
program.

thanks

ray
Back to top
View user's profile Send private message
stephenbye
Site Admin


Joined: 12 Aug 2007
Posts: 78

PostPosted: Tue Jun 24, 2008 10:20 pm    Post subject: Reply with quote

On a normal worksheet, you can refer to other cells using one of these methods:

A cell on this sheet:
A1

A cell on a specific sheet:
Sheet2!A1

A cell on a specific sheet in a specific file:
[File2.xls]Sheet3!A1

On a macro sheet, there is an additional method to refer to other cells, like this:
!A1
this means a cell on whichever sheet is the currently "active" (visible) sheet.
Back to top
View user's profile Send private message Send e-mail
thinman



Joined: 13 Jun 2008
Posts: 8

PostPosted: Tue Jun 24, 2008 10:40 pm    Post subject: Reply with quote

Thanks...

ray
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SpreadCE / Spread32 Forum Index -> General All times are GMT
Page 1 of 1   

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Community Chest


Powered by phpBB
Hosted by FreeForums.org