Selecting Ranges to print
Thu, 2 Oct 2008 11:29:01 -0700
I have a file with several worksheets all having formulas from row 8 to row
78. I would like to be able create a macro that sets the print range to end
on the row where the last formula has retrieved data on each worksheet. For
example, sheet1 may end on row 31 while sheet2 ends on row 55, etc. The
retrie ...
|
Solver Automation Problem
Thu, 2 Oct 2008 11:26:00 -0700
Solver works fine in one of my VBA programs on my PC which has Excel 2003,
but a co-worker who uses the same program has encountered a problem. His
problem started when he switched from Excel 2003 to Excel 2007, and then
switched back to Excel 2003 when macros that used to work in Excel 2003
wouldn't funct ...
|
Scrollbar changing dollars
Thu, 2 Oct 2008 11:19:02 -0700
I have a scroll bar connected to a cell which changes the dollar value shown
in the cell. The problem is it only shows dollars and 00 cents. Is there a
way to change the properties of the bar to change by the penny, not just by
the dollar? ...
|
Password protect select sheets in a workbook
Thu, 2 Oct 2008 10:58:00 -0700
The macro below protects all worksheets in my workbook. I only want to
protect specific worksheets with the names Menu1, Menu2, etc. How would i
modify the macro to accomplish this. I know I can just select each worksheet
and protect it but I would like to learn the more advanced version below.
Sub Protect ...
|
Conditional formatting - why doesn't this work?
Thu, 2 Oct 2008 09:43:03 -0700
Please help, I'm stumped.
I've set up a worksheet calculate macro to colour certain rows based on the
contents of the adjacent cells, but one of the specifications isn't working
and I've tried everything.
This spec works:
'Highlight if later than 90 days since request
ElseIf myCE.Value < Now - 90 A ...
|
Macro not finding last cell in range
Thu, 2 Oct 2008 09:13:00 -0700
Hi,
I have a macro I have been using in a workbook for about 6 months with no
problem. Last week, when someone else used the same file, the macro no
longer works properly.
In short, I have a form that once completed, the macro prints certain
worksheets, copies a specific range of one worksheet, opens ...
|
Macro needed Appointment Scheduler
Thu, 2 Oct 2008 09:01:02 -0700
Hi all
Any help on this would be appreciated. I manage a call center that does
outbound appointment scheduling for a variety of clients. I need to create a
macro that would take certain information(Columns A, C, I, K, & L) from the
call sheet and paste it into a separate worksheet when Column N = xx .
Id ...
|
|
|
"&" symbol in header/footer
Thu, 2 Oct 2008 08:58:21 -0700
I am looking to have the symbol & written in my header, i tried many ways
"&", ="&", '&', ... it just won't show up. Is there anyway to make it show up
? Maybe ascii code but i don't know how ??
PLEASE, do not answer to write "and" instead, I had already figured this one
out :) ...
|
Copy / Paste / ESC Key ?
Thu, 2 Oct 2008 08:55:02 -0700
My code sends data from one tab over to a number of tabs. After doing so I
want it to return to the first tab and be ready for the user to press another
button if needed. But right now when I return the row that was copied still
has the squiggly line around it. I do not want the user to have to press the
...
|
VBA: Adding contents of a cell to a chart as a textbox (or image,
Thu, 2 Oct 2008 08:14:01 -0700
Hi,
I am in the process of creating a macro which subtotals sheets by a column
value (which contains survey respondents' ID, such as "Respondent 205", etc).
The subtotals compute averages.
I have written code which find's each person's range of averages and plots
them. Each person gets their own chart an ...
|
