Hi:
Is there an easy way to convert month names, say 'Jan', to 1 and 'Dec' to 12?
On a worksheet I have a ComboBox where users could chose a month and then a cell where users could key ...
I'm sitting in cell A1. Cell B1 has a date and Cell C1, C2, C3, C4 all contain different dates. I want to say the following
if B1 is between C1 and C2, cell A1 will be red
if B1 is betwe...
Hi there
Can anybody give me a piece of code that merge adjective two cells into one?
Using Merge function in Excell wipe away the data of right side of the cell.
I don't want to loose le...
Hi experts,
I have some data from sqlserver imported into an excel spreadsheet. I have also plotted a graph on the same sheet.
How do i write a macro to auto refresh excel one very minute...
I need to provide information for a database. I have pictures then information relating to that picture (maybe 6 or 7 fields). I tried "Insert -> Picture -> from a file"
It put the pictu...
What is the Excel version of Word's "normal.dot"?
I need to calculate the standard deviation for 11 data points (see below). I'm familiar with Excel's formula:
=StDev(cellrange).
Based on data, I'm not sure which column (B or C) I sho...
I report on a lot of data provided to me from users. Most of the time I get columns that are used to designate some of that data one way or another. For instance, a column with "yes" or "no"...
I am writing an Excel macro to save a file as *.xml. I need to keep the SaveAs path relative because my clients may store these files anywhere on a shared drive or web server. I am not sure of...
When I attempt to open two differenct Microsoft Excel files, I get an error message stating the the file format is not valid.
I am able to open these Excel files in Word.
I need to get t...
I have an application that needs to add OptionButtons dynamically. I currently have the following code:
ActiveSheet.OLEObjects.Add(ClassType:="Forms.OptionButton.1", Link:=Fals...
Hi,
I'm trying to create a dynamic drop down list in excel.
I have a column of data and I want to make a drop down list from source criteria listed on a separate sheet.
How do I do this...
I don't have a good experience in Excel program so I want to put a date like dd-mm-yyyy in a cell like
1-Jan-2005 and in other cell 5-jan-2008 then I need to subtract two from one to get res...
I am looking for a VBA that will find the first empty cell in a column and copy the cell directly above it and then go on to the next and do the same until the end of the spreadsheet.
Ideal...
Hi experts,
I am creating a macro to display a list of document numbers based on the transaction code selected from a combo box. The list is displayed on the same sheet (Sheet1).
For ea...
I am using conditional formatting to set the cell colour based on cell value. Conditions are: =0, between 0.01 and 0.09, else I want the existing cell colour left as is. This works fine for ...
Hi,
I'm trying to work out the Compound Annual Growth Rate of company PROFITs.
The standard CAGR equation is:
=((end / start) ^ (1 / years) - 1)
That's fine where 'end' and 'start' are...
HI,
I want to write a Macro in Excel
Like if in macro I write below code it selects the cells A1 till F1.
Thats fine.
I want to get the value written in column F10. How to get ...
Is there a way to suppress "Macro Enable/Disable" prompt (forcing it to take Enable option).
I am oening hundreds of xls file and they contain macros. I want the macros to be executed witho...
Hi, I am working through Microsoft Knowledge Base Article 213772 "How to Use System, User, and File Data Sources"
It describes how to use an Excel VBA Macro to link up (via ODBC) to the MS ...
In Excel. I'm trying to perform two calculations.
The first calculation is the difference between two times: start time and end time. This column is in the datetime formatting and list...
Team,
I have 6 SUB procedures and to run all the 6 SUB procedures is taking me a while to run. I need a progress bar which displays the name of the current module the file is running and ho...
I am currently running Excel 2000 and I am sending off workbooks with simple vba codes that show userforms. Everyone who is running Excel 2000 in my company can view the workbook correctly. Th...
Hi,
I've coded a macro that will loop a set of data and pick out the row range that needs to be copied over.
When I try typing this:
Rows(startCutRow & ":" & endCutRow).Select
I ge...
Hi,
I need a way to convert millatery time value between two cells.
I.e.
A B C
1730 2130 04:00
So user enters 1730 and 2130 in relevant cells, ...
