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...
I need a macro or vb code to find and delete all blank rows and columns in an excel workbook.
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 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...
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...
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 ...
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...
How would you export data from Excel so as to get just the data, not formating info & no namespace info? Can you get a file exported that is as clean as this attached xml?
Hello Experts, i want to achive the following:
I have a single column in Excel with around 1000 rows filled with text up to around 30 words.
What I want to do is get a list of the most frequ...
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 an Excel worksheet with a dynamic range of data and want to copy the range after it is filled (from another query) and paste only results where the first column says "MISSING" to anothe...
I have 3 pools of information:
Calls Answered Within 30 Secs
Calls Abandoned Within 30 Secs
Total Demand
With the above information I'd like help in creating a userform in either Excel...
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
...
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 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...
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 ...
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...
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....
Dear Experts,
We are developing a method to read the content of a large text file which is the exported result of a database query. The intention is to rearrange content in a suitable way t...
I have financial statements that are in Excel and linked to Word. Underlines are in the Excel spreadsheet and appear on my screen and when I do a print preview. However, when I try to print ...
Hi all.
I am having a little problem with my Pivot Table that I have not run into before.
I am using a Date field for my row label and am trying to sort the table by this date. No matter ...
Assuming I have data like this:
A B C D
1 Dev, X1, X2, X3
2 Test, X1, X3, X3
3 Dev, X2, X1, TT
I want to do a COUNTIF( A1:D3, "X1") but only where A = "Dev"
I have this same problem, and tried all the solution steps to no avail.... maybe like 15016164 above.
The Excel file says it reserved by another user who is not present and not using it, so...
Hi Experts
In part of my code, I am trying to set the first and last dates in a range to use further in the code:
e.g, for 11/04/08, if I set the format first as "dd mmm yyyy" it reads cor...
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 :) .
