Hi
I would like to change the print area based on VBA excel coding.
First off there are many tabs in this workbook. So I need it to loop and apply the print area individually.
In all t...
I was wondering if there was a way to deploy a newly created add in to both Excel 2003 and Excel 2007 within a AD Domain Environment.
I wan to import data that I have in a txt file to excel. This is for a flashcard program. I need the question to be in column A and the answer to be in column B.
Anyone know the easiest wa...
I have a column in an Excel spreadsheet which has a 6 digit number with two trailiing zeros at the end. I would like to be able to trim these two trailing zeros off using a macro. How can I ...
I want to find the best way to create a manual call stack.
Hi,
Need an Excel macro that can add comments to the description for all computers in the excel colum "Q". The computers are in the Active directory in different Ou's.
Search all the OU's...
We have a spreadsheet for staffing information. It contains columns for First Name, Last Name, Hire Date, Length of Service, etc. We also are able to download a CSV file from our payroll/tim...
Im trying to find a way of selecting multiple ranges in VBA. It is possible in excel : Select first range
...
I wish to apply a fancy conditional-format that shows whether an incorrect value has been entered in a cell.
This would be based on check digit logic given at the following site:
http://ww...
Office 2007 - If I have a Excel Spredsheet on the my desktop - and I go to open the file, excel will open
but will not load the sheet..
Can anyone help me
Hi, i am using vba to open excel files and one zipped access mde file on an intranet. I can get the application to work when i copy the files locally and run my app. It simply opens the variou...
Is there a way to change the color of a command button (say to green) after it has been clicked? Then reset the color back to red by clicking another command button.
Hello,
I need some code that will tell a web query specifically when to update. Once the update is completed, then I need this most resent data to be placed into the corresponding time locati...
We have a spreadsheet that has multiple tabs and in those tabs, cells that show if a certain link is up, down or degraded and has a color that corresponds to each. Red=Down, Yellow=Degraded, ...
I have files that have Macros in them that I want to always run when the file is opened. I would like to make it so when the file is opened and automaticly goes to the index page it also sets...
I used a formula to create the values ac8:ac170 and $ac$8:$ac$170 in Cell AC1 in the Sheet M Data . The values appear to be correct visually in the spreadsheet. I would like to use these ...
I have a number of worksheets with formulas that refer to a common worksheet in the workbook. I've redesigned my template so that I now need to transpose the data on the common worksheet. Co...
Hi Experts,
How can i detect if a name is defined in an Excel workbook programmatically using VBA?
If the name exists I want it deleted using ActiveWorkbook.Names("NoOfTripsMultiStop")
...
Hello
I am using an Index function ... =INDEX(data,$B$2,1) ... to return values into a single line subject to what is selected by a list box (list box is linked to cell B2)
The index looks u...
hi
i have
$900.00
-$350.00
$900.00
$900.00
-$350.00
$900.00
total -700
I need a formula to sum only the negative ones values,
is any way to do this
thank you
edo
Hino
I have to run some code in Excel VBA before someone double clicks
on the listbox. I see there is no _BeforeDoubleClick event
Is it possible to generate one or is there an equivale...
I am developing a user-defined function (UDF) that needs to switch between six possible named ranges:
GROUP A
"Bids_A" (on worksheet "Bids-A")
"Bids_A_GID" (on worksheet "Bids-A")
"Bids_...
I am having trouble with a Word document which has several links to an Excel document. Both are saved in the 2003 format. However, a lot of the linking was actually done on a computer utilizin...
user has two tabs on excel spread sheet,
1. for receiving goods
2. for sending goods
now when she used to update it and click save, it says calculating cells and then update another tab of...
