Recent content by Wookiee

Luke, I appreciate your help and suggestions and I apologize that I wasn't clear in my original statement. :oops: While your proposed method of calling the hyperlinked file from a maximized source file does put each application up on opposite screens, I would prefer to not have either of the...

It acts as I described regardless of whether the source file with the hyperlink is maximized or regular sized (although the hyperlinked file opens on the opposite monitor).

Thanks, bobhc! Although I would prefer to handle the issue specifically when a hyperlinked file is opened, I will certainly try to play around with that Application Event Handler code if I can find no other solution. And as for razors, those are things which I am aware exist, but rarely do I...

It's a desktop and both of the monitors are plugged directly into my PC.

Hello, all! I've noticed a behavior pattern with Word and Excel which annoys me and I have been so far unable to find out if there's anything I can do to make it stop. Allow me to elucidate: I have a number of Word documents which describe various reporting functions I perform. Many of those...

Thank you all very much for the responses! Haseeb, your formula fit my purposes quite nicely, although I shortened it as shown below to avoid the IF evaluation and hopefully save a little memory since there's the potential for several thousand records to appear in the SMR spreadsheet...

Hello, all. I have tried a number of searches to help me figure out how to solve my problem, but either I'm not wording my queries correctly or no one has asked this question (I'm guessing it's the former). :confused: Here is my situation. I have 2 worksheets which both contain a column...

I think this should do the trick. Please let me know if you find otherwise: Private Sub Worksheet_Change(ByVal Target As Range) Dim rngWatch As Range Set rngWatch = [A3:A15] If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, rngWatch) Is Nothing Then Exit Sub If Target = "T"...

PipBoy, while my code works, Narayan's employs the best practice of qualifying the worksheet for range references. It's something that I know I should do more often, but usually don't. And since I didn't know whether you would be incorporating that code into a larger macro or just using it...

I'm sorry to say I can't think of much of a reason why the same file would work in Excel 2010/2013 but not in 2007. The only possible problems I could think of are that either you didn't enable macros for that particular workbook or the code isn't located in ThisWorkbook?

You're welcome, Kinghart. Always glad to help!

This code should work if you place it in the worksheet for which you want the custom behavior: Private Sub Worksheet_Change(ByVal Target As Range) If Not Target.Address = "$A$3" Then Exit Sub If Target = "T" Then Range("C3").Formula = "=SUM($D$3+$E$3)" ElseIf Target = "" Then...

Oh man. That's the second time this morning that I've taken so long to respond to a question that you've beaten me to the punch, Narayan. But I have to thank you even though this isn't my thread. I've never seen that method you used, and I like it better than my For..Next loop.

How's this work for you? Sub Switcher() Dim rngCell As Range For Each rngCell In Range("A1:A20") If rngCell.Value = 0 Then rngCell = "Closed" Next rngCell End Sub

Hmmm. I haven't seen that one before, but a quick Google search leads me to suspect that maybe you're trying to use that code in a Function rather than a Sub procedure? If that's the case, the error doesn't surprise me because (at least as far as I understand it) functions can only produce a...