Search results

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...

George, I use 2007 at work and I've got a file with a Workbook_BeforeSave macro that works every time. Are you getting an error message, or is the macro just completely failing to initialize?

You'll probably have to use the macro recorder to figure out the exact syntax for the formula you want to enter, but this code should work for the purposes of evaluating cell A3. If Range("A3") = "T" Then Range("C3").Formula = "=Insert Your Formula Here"

This is a cross-post. I'm not usually one to do so, and I hope I'm not committing an egregious sin in the hallowed halls of this shiny new forum, but so far no one in the Mr Excel community has had any advice or suggestions. The problem is an error code which only periodically affects a small...

Let me try this out. Sub New_Forum() Dim strMsg As String strMsg = "The new forum looks good. I like it." Msgbox strMsg End Sub

thanks, sirjb7. i am familiar with the general forum conventions, i just somehow found this topic link from another chandoo post and was curious about the logic that jmackey was using. although i did realize the age of the original thread, i felt it most appropriate to post a reply here since it...

@ jmackeyiii (or anyone else who'd like to chime in, since it looks like jmackeyiii hasn't ever posted since his intial post in this thread) i'm trying to wrap my head around the use of the ROW function to generate a series of numbers in specific increments. although i'm not sure how i would...

A lot of times, there is cell formatting in unused cells which can lead to file bloat. Even when you hide unused rows and columns, the formatting data is saved (and I suspect that probably applies even when you delete those rows and columns). If you copy only the cells with data into a new...

It occurred to me you might want to work from a list of folders instead of manually creating an array in your code. Below is an alternate version of my macro. It still uses all the constant variables from the first code, but this module will loop through a list of values in Column A to get the...

First off, I love that user name! Second, yes, you most certainly can create folder with Excel VBA. Here's a bit of code I put together which creates a series of folders and subfolders. You might have to play around with it to get it set up with the structure you like, but I think it's a good...

Hello, Kaushik. I hope my suggestion works as a viable solution for you. Please allow me to clarify my statements. 1 - The Macros folder doesn't hold all macros I and some others use, but it does hold all the macros which we want to make commonly available. 2 - Yes. Every user has to set up...