Search:

HP Printer as default was causing my Excel errors and crashing.
I had a few lines that set up margins, headers.
By turning off communication with the printer during these commands it allowed my...

Recreated all my files (addins,templates,Access databases) from "parts" in Office 2010 to eliminate any conversion issues from prior Office versions.
That got me to the point where my macro runs...

Corporate IT installed AV...Sophos Protection not possible to disable.
I have just rolled out this Excel-based Add-in app to a new group of users and only one user so far is reporting this behavior....

This is is my Windows update history for the week:

Security Update for Windows 7 (KB2536276)
Installation date: ‎8/‎15/‎2011 10:00 AM
Installation status: Successful
Update type: Important
A...

Setting the "Trusted Locations" for my Add-In folder is a great idea. I did that. And then it actually was able to run successfully once.
But it is now back to crashing. It crashes at different...

I also have the same problem starting last night. Another user within the company reported macro crashing Excel. I shared his screen and watched it happen. Then last night it began to happen to me...

<P ID="edit" class=small>(Edited by Phil Rabichow on 02-Feb-04 13:35. if you have Option Explicit set in your VBE, you had to add the following two lines somewhere near the beginning:

Dim fraction...

If Selection.ShapeRange.Fill.GradientVariant > 0 Then MsgBox "Gradient!"

{IF {SECTIONPAGES} = {PAGE} {FILENAME p}}

... works only if you reset the page numbering to 1 at the beginning of each section.

Another solution is to just put the {FILENAME} field wherever...

Many years ago we had a high school student as a summer intern. He thought he'd teach himself to make macros. So he recorded a macro. He just did a little stream-of-consciousness typing, ended the...

Hey Don,

I am in awe of the elegant and mathematical formulas that complex minds concoct. But I'm a simple country girl. Some would say simple-minded. So this is how I'd solve your problem: a...

Leanne:

This macro will clear out the ranges for ANY grid in the workbook. Since the user cuts & pastes them, I'm assuming all 55 look the same in layout.
The user must have a "Station" cell...

A shortcut on the user's desktop or Office Shortcut Bar usually helps folks get a fresh copy of the template without tears, too.

Now *THAT* is sexy! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

<hr>You just did thank us.<hr>

Nice going, Steve. I was going to suggest a batch of homemade brownies. Oh well... <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>

If you post here with an attached Excel file showing a simplified example of what you want, that would be helpful.
Using a VLOOKUP formula in A might be the answer if your "hidden data" is a...

You said, "the hidden data shrinks and expands in terms of rows"

Hmmmm... <img src=/S/confused.gif border=0 alt=confused width=15 height=20> Does that mean you want your formula "=Z1" to stay...

Hey, Leanne! Have you considered using an Excel Template?

You just take a "virgin" copy of the spreadsheet (all cleared out and ready to go) and save it with the extension .XLT instead of .XLS.
...

To paraphrase the fellas down at "Dockside Dolls" gentlemens club, "SHOW US YER CODE!" <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

You probably have code in both the subroutine...

That Envelopes & Labels menu choice steers many in the wrong direction who really wanted mail merge labels.
I'm assuming the labels are all different addresses. Mail merge is ideal for this. If...

Textboxes don't rotate. You can use WordArt to get that effect. You just have to spend a bit of time getting rid of all the frou-frou shading and 3-D and skewy-stretchy stuff first -- unless your...

Alan:

For "conditional text" in a form letter I usually store the text as an Autotext with the formatting already applied. After the user provides some input (usually picking a radio or checkbox...

Right you are, Alan. In Word's Tools...Macros... menu, it is called the "Visual Basic Editor". I wouldn't send anyone over to Visual Basic 6.0 for a simple trick like this! <img src=/S/smile.gif...

Potential problem using MS Graph within an Access report? Mood swings, fatigue, irritability, and hair loss are all I've heard about. Thanks for the link. <img src=/S/wink.gif border=0...

You're reading me mind, 007!

Since I usually operate in organizations where the IT staff has little to offer in the way of app development, I create a lot of applications-in-a-template for my...