Search results

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

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

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

I've been wracking my brain for a few hours now trying to come up with a solution to this problem, so I've broken down and decided to ask my friends at PHD for some advice. I have a report that I compile daily (I pull it from a different report with about 12 times more data than I need). There...

When creating text arrays in VBA, I've found that it can be quite tedious to type every single item in an array, especially if the list is long. So I created this macro which will take a list of values in Column A of the active worksheet and produce an array in Cell C5. You can then copy the...