[mso] Re: Two questions about Excel
- From: "Greg Chapman" <greg@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 10 Dec 2002 16:40:00 -0600
If you're defining the functions in the cells, you're stuck with the
options Linda describes. If you get just a hair deeper, though, and
engage VBA, you could define a VBA subroutine to do the job for you.
Something like this:
Sub DoSomeWorkwithCellResults()
If not IsEmpty(cell) Then 'determines whether cell is blank
Select Case cell
Case "This"
DoThisThing
Case That
DoThatThing
Case Else
DoSomeDefaultThing
End Select
End If
End Sub
Greg Chapman
http://www.mousetrax.com
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Colli, Anthony G
> Sent: Tuesday, December 10, 2002 12:42 PM
> To: MSO FreeLists (E-mail)
> Subject: [mso] Two questions about Excel
>
>
> Folks-
>
> I need to do some comparisons in Excel. Basically if this
> cell = this value then I want this output. I need to write
> this in a function that can be used in other spreadsheets. I
> have written the function and it works but here is my
> question. How does Excel treat a blank or empty cell? is it's
> value '0' or "" or null?
>
> Also when I am working with this and I modify the function,
> is there a way to recalculate the spreadsheet? After I change
> the function the values are not updated.
>
> -Anthony
>
>
>
>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to
> mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to
> mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
>
> Or, visit the group's homepage and use the dropdown menu.
> This will also allow you to change your email settings to
> digest or vacation (no mail). //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with
> the group, send a request to mso-moderators@xxxxxxxxxxxxx and
> you will be sent an invitation with instructions. Once you
> are a member of the files group, you can go here to
> upload/download files: http://www.smartgroups.com/vault/msofiles
> *************************************************************
>
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
