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 ...
Using the programmatic SaveAs method in MSExcel 2003 to save the workbook as a comma delimited (*.CSV) the user doesnt get the message
"*.CSV may contain features that are not com[patib...
Experts,
Within my VBA code (ThisWorksheet - Sub SortImportedData_To_TEMP) (see attached) it ends up creating formatted output on worksheet TEMP.
What I need to do is calculate EFFECTIVE...
I have a checkbox in sheet1 when checked, a Msgbox will appear. Is it possible to change the colour of the msgbox to red instead of the default colour?
Private Sub CheckBox1_Click()
If She...
I'm trying to use VBA to select multiple rows of data based on certain conditions being met in the cells in those rows. I then want to have VBA automatically select those rows and paste them i...
I have a database that I import excel spreadsheets into. I am now reveiving workbooks with multiple worksheets. The names vary so I need to be able to select the worksheet to import. I am a...
Using Excel 2002 with auto wrap extra space is added to the cell. I have reading other posts that row height adjust may be turned off when we use wrap text... Is this true? Is there some way ...
I need a macro or vb code to find and delete all blank rows and columns in an excel workbook.
I am not able to convert a number greater than 24 into h:m:s
I use the formula =(H5/24;"hh:mm:ss") but this only works up to 24.
When I try this with 27.50, the result is 03:30:00 because ...
Experts,
I am trying to add some more functionality to the end of my code. What I want to do is copy the entire row of data from sheets( TEMP ) to sheets( GROUP )
Code for this exists in...
i'd rather not hand code 400 checkboxes...
i have a user form that allows me to type in all holidays (upto 20) and all locations (upto 20). i have build a worksheet with range names Loc1Hol...
Hi,
I have a excel workbook in which have more then 5 work sheet and that excell workbook is password protected and I just want to edit in that workbook.
Please some one tell me how can I d...
I would like to atomically hide column "N" when cell "N5" is blank, but once cell "N5" has data in it again I want Excel to automatically unhide column "N". Can this be done?
I'm gues...
Hi,
I need to know how to do the following;
If I create a dropdown list in the cell A1 of 1-6, can I automatically populate the adjacent columns with a colour based on what value is select...
I have a spreadsheet with columns as the categories for data (i,e. name, position, status, ect.). I would like to highlight the ROWS in red that have "No" in column H and highlight the ROWS i...
Using a macro\VBA want to read the color of a range of conditional cells and change some referenced objects to the same color. I have shapes of states and want to change the color based on th...
I have a formula that compares two columns of Summary Data on two different worksheets which changes the formatting of the ActiveSheet Cell # that doesn't reconcile (= each other) and also pla...
I have one user who is having slowness when opening excel files both from the network and locally.
The users computer is as follows Latitude D620 dual processors at 1.8ghz, 1gb ram, Windows...
Hello experts,
I have a large pivot and I am trying to build a chart that will change the values depending on what row is selected. I am feeding the chart off a series of cells in A1 throug...
Hi,
I am trying to create a simple line graph showing correlation between one variable and the result. If thrust increases distance increases. I have the following data:
Thrust Distance
...
Hi:
I'm running into sum inconsistencies/issues when attempting to programatically a cell format.
I would like to set a cell to be of type "text"
(I need to do this for various reasons ...
I have a spreadsheet that is tracking ownerships of land parcels for importing into a database.
Currently it has about 300+ records (rows). In column A, there is a field named Sort_Key. T...
I am trying to calculate the number of days on in a month from the date field.... without entering the start day and the end day. I wish that it is possible :) .
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:
I have an excel sheet that when opened runs a macro that refreshes a Pivot table.
This is the macro code.
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh
Application....
