Replies

… please ignore my last post. ISFORMULA is what I will be adding as VB code (sorry, for my ignorance, I’m self-taught with macros)
–cat

… I don’t have the function “ISFORMULA”. I have a lot of other “IS STUFF”, though. Is there an add-in I should select to get this function?
Thanks,
–cat

Steve … thanks a bunch for responding so quickly! (I’m on a tight schedule, so I’ll go try it right now and let you know …)
–Cindy

Steve … thanks a bunch for responding so quickly! (I’m on a tight schedule, so I’ll go try it right now and let you know …)
–Cindy

John, I’m looking for all files in a directory, but it could be a named range that I maintain within the excel file.
Cindy

John, I’m looking for all files in a directory, but it could be a named range that I maintain within the excel file.
Cindy

Hi Steve, thanks.
I have never used a UserForm (or the Combo Box within it) … and I’m a self-taught VB user (which could explain a lot of things!). If you could help with some basic code for a UserForm that uses a combo box … I could probably take it from there. (Hopefully!)
Thanks,
–cat

Hi Steve, thanks.
I have never used a UserForm (or the Combo Box within it) … and I’m a self-taught VB user (which could explain a lot of things!). If you could help with some basic code for a UserForm that uses a combo box … I could probably take it from there. (Hopefully!)
Thanks,
–cat

I think you have your OR parameters messed up ..
If you want this:
IF(A1=OR(“A”, “B”, “C”, “D”), “yes”,”no”)
Try this:
=IF (OR(A1=”A”,A1=”B”,A1=”C”,A1=”D”),”YES”,”NO”)

kinda cumbersome, but that’s how it works.

–CAT

I think you have your OR parameters messed up ..
If you want this:
IF(A1=OR(“A”, “B”, “C”, “D”), “yes”,”no”)
Try this:
=IF (OR(A1=”A”,A1=”B”,A1=”C”,A1=”D”),”YES”,”NO”)

kinda cumbersome, but that’s how it works.

–CAT

Hans, … you’re saving my hide today! I’m on a very tight deadline … new job and all so I do want to impress. Unfortunately, or fortunately, I am a self-taught Excel & VB user. When I actually record my macros and then add to them, the viewer is subjected to “watching” the activities. Is there a way to disable that?
Thanks, again.
–cat

Thanks … as for events … that’s the “Workbook_Open” and the “Before_Close” events, correct?
–cat

Thanks guys … you are very very helpful.
–cat

WONDERFUL … you guys are great! That worked perfectly
–cat

Thanks, that works if all the possible worksheets are open. I get an error if even one of them is already hidden. My problem is that I don’t know which ones are visible when the worksheet is saved. Any ideas?
-cat