I am analyzing performance of Projects, which are around 30000 rows of
information and 160 Columns of information. This is contained in a Worksheet
named Projects-06
I want to achieve the following in a blank worksheet in the same workbook,

I'm thinking you may need some VBA to do the rest of what you want. You may
want to post this in the PROGRAMMING group to see what they say.
"DTTODGG" wrote:

I want to align an autoshape using vba with some cells on a
spreadsheet... I picked up the following from this newsgroup a while
back:
"Use something like the following to align the top left hand corner of

Thanks for the great code everyone on my printing problem.  Works great!
Now, I have would like to make an addition to the code that
unselects/deactivates the sheets that were printed vis the command "Printout"
I see there is a deactivate command, but I am getting an error trying ...

I use a CAD program that show the open file's full path in the active
window's title bar. Very useful for knowing exactly where the file came from.
Is that feature available in any of the MS Office modules?

I have created a custom macro toolbar that we want to deploy to about 3 to 4
users. I have already updated everyone's Personal macro workbook with the
updated macros. How can I put the updated macro toolbar in each user's Excel,
without overwriting all of their other settings? I ...

I have a spreadsheet that is to be run entirely from a userform.  I
currently have it set up so when it is opened, the userform pops up and
excel is minimized.  I also tried adding code that someone had posted,
to minimize the form to the taskbar.  It worked well except it messed

I am getting an "out-of-range" error on this code:
Private Sub PrintButton1_Click()
If IsEmpty(Worksheets("Sheet1").Range("A8").Value) Then
   Worksheets("Sheet1").PrintOut Copies:=1

Copy of message from Excel General Question - 9/26/2006 1:22 AM PST
Does anyone know on how to code on following condition in this group?
[row 1] a blank row
[row 2] 10, which should be equal to the last value in row 3

Hi all...I'm working on a spreadsheet that reads project management data
from a spreadsheet that's exported from an accounting application and
generates about 20 separate workbooks, one for each project manager. The
workbooks are then distributed to the individual project ...

I have a problem using events with a listbox.
I have a first listbox, named "listbox1", and I want to display a second
listbox  "listbox3" when the user selects a value of the first listbox. I
thought I could use the change or afterupdate events, placed in the userform

Good Morning!
I am trying to hard code an error message for invalid data format entered to
a formatted field.
I have selected cells B11 through B30 and set is to positive number with

I tried to write code which should do actions like:
1. If user try to close file its should ask if the file should be
saved.
- If NO file should be closed immediately without any prompts (like "Do

Is there a way to setup the print button to check a cell for a non-blank
status in each sheet of a workbook and have that sheet print based on the
status of the cell?  Thanks!

A coworker has given me a spreadsheet that pulls data from an Oracle database.
He has no problem running the macro, but when I try to run it I get error
'429' ActiveX Component can't create object.
Here's the line that causes the error: