How do I: If Pie Section Label = X, Make Pie Section Color = Y
Wed, 3 Sep 2008 07:29:01 -0700
A question for any of the Masters of Excel out there,
How do I go through all the data labels in a Pie Chart, look for a specific
label text, then change the pie slice color based on what the label says?
The reason for this excercise is that the order of the data may change but I
want to make the pie slice ...
|
Run-time error â??1004â??
Wed, 3 Sep 2008 07:07:00 -0700
I have the following macro in a workbook and a user keeps getting the same
runtime error that I cannot duplicate.
MACRO CODE---------------------------------
Sub Quote_Wrapup()
'To stop screen flicker
Application.ScreenUpdating = False
Range("quote_date").Select
Selection.Copy
Se ...
|
To determine that cell is on top of page
Wed, 3 Sep 2008 17:41:16 +0400
Hi,
Is there a way to determine that the cell is on the top of the page, e.g. in
Page Break Preview?
Thank you.
--
Andrei.
...
|
Reading from a folder
Wed, 3 Sep 2008 06:32:01 -0700
Hi,
Is there any macro codes that I can use to read all the file names in a
particular folder or path and print the file names to an excel worksheet?
...
|
Macro !!
Wed, 3 Sep 2008 06:01:33 -0700 (PDT)
Hi,
I have excel sheet having 6 coulmns
Col A - Names
col B - Address
col C - Date
Col D - Login
Col E - Any changes in login
col F - Date of change in login
If the user changes the login time in col E... automatically only that
person's
details will reflect in other sheet.
I need macro to run thi ...
|
Locking cells using VBA based on other cell values
Wed, 3 Sep 2008 05:58:00 -0700
Hi,
I'm trying to lock cells in a column on an excel spreadsheet depending on
the (date) value in another cell on the same row. For example, I'm thinking
of it like this:
If range("C9").value > today()
Then range("G9").lock = false
Else range("G9").lock = true
...
|
Do I need to destroy a collection I made when I am done with it?
Wed, 3 Sep 2008 05:34:01 -0700
I have some code that intializes a new collection, runs code using the
collection and then ends. Do I need to destroy the collection so it doesn't
take up memory or does this automatically happen when the procedure is over?
Is there a way to see what is in memory?
Option Explicit
Private Sub cboMounting_ ...
|
|
|
Macro to print to IP address
Wed, 3 Sep 2008 04:48:01 -0700
Can someone help me with a macro to print to an IP address. I have a stand
alone network printer that i want to print to and everyone has the printer
named differently on their computer. The only constant is the IP address.
Thanks in advance,
Larry ...
|
How to make First letter of the cell in capital letter
Wed, 3 Sep 2008 02:01:01 -0700
I have a sheet in which there are text matters.
I want to run a code, so that all the cells of the worksheet can be effected
to change the first letter of the cell into capital.
I was able to know with the web helps examples, by that I can do it manually
with the cell reference one by one. the formula is a ...
|
Emailing Spreadsheet as a body
Wed, 3 Sep 2008 01:47:01 -0700
Hello, I'm just wondering if its possible VBA wise to send a spreadsheet (a
particular sheet) in an email within the body, rather than a file.
Cheers for any advice. ...
|
