I need to search for a certain string value, say "Hello" in my worksheet & wherever the value is found, I need to delete the value in the cell BELOW IT (not the value of the cell with the "Hel...
On the attached spreadsheet, tab 2008 3rd Q, I can set conditional formatting to highlight a cell when a specified letter/s is typed in the cell. I then count these different letter/s to get a...
Hi.
i have these values
0:01:10
0:03:46
0:01:29
0:01:07
0:01:00
0:01:00
0:06:11
0:01:00
I converte them to time (hh:mm:ss)
and i want to sum the values, but using the formula ...
Look at the attachment.
The top part of the view shows the script and the lower part of the view shows the result set. The field 'hist_date' is varchar2(10).
The script is also copied bel...
Can anyone provide VBA code to validate custom number formats (e.g. "#,##0", "0.0%")? I am creating a userform that allows the user to enter custom number formats, and need a way to validate....
Hi Guys,
Using the code below to Copy and paste special some values from one workbook to another.
Getting the "Large aount of data on Clipboard would like to save this .. etc etc" msg bo...
Hello,
I am creating a full, automatic-populating quote sheet for my company, and came up with a cosmetic issue relating to empty rows. Due to some products having more line items than othe...
I want users to input data into an excel form and when they click 'OK/Submit'. The data should be populated into the spreadsheet.
I have created a draft form and sample data in the attached s...
Dear experts,
We are using MS Office 2007.
We have some CSV files that contains UTF-8 chars with the correct BOM (Using a binary editor, I checked that the file starts with "EF BB BF").
...
I am trying to run a Macro from Excel that looks through a range of cells and for each cell that is not empty, it takes the value in that cell, opens a word XML template, does find and replace...
Hi I have this error whenever I open my spreadsheet. The debuger then opens this code highlighting Line 7
It only happens each time I close and reopen the spreadsheet.
Thanks.
I need to add some column headings to a spreadsheet created by a macro, the example spreadsheet shows on sheet 1 what the original macro creates and sheet 2 shows what I need to do with the da...
I have an excel macro that I inhereited. it is programmed to cycle through an excel worksheet, find the name of a file, open the file and then cycle thorough a column of data copy it and paste...
Helllo Experts,
I am getting a little weird error which I am not able to fix. When I run one macro it is giving the above mentioned error for this statement
Set oFX = New FXConnect.FXApp...
I found the following code (posted by zorvek) that allows me to find and replace carriage returns and if change it from chr(10) to chr(13) i can remove line feeds. The issue is that I want to ...
Hi,
I have this macro which I pulled off the net to automatically create named ranges per column with unknown number of rows.
Apparently, I'm doing something wrong. Running the macro, gi...
Hi. I am getting date info formatted like this from a mysql backup:
1256092787
How can I convert this to a normal date and time format in Excel?
Hi Guys,
In the attached workbook (this is a sample only) I am trying to build table and then plot a graph of the data in that table. the Graph is already present and I use the code to res...
Hi EE,
screen shot 1 - show a chart with default x axis category font settings
screen shot 2 - shows a chart after i clicked on the x axis category area
then cli...
Can anyone share an example of how to:
1) have a budget data for each month
2) Have Actual data
3) and in the pivot table show the actual data and the variance between both.
I have a spreadsheet that is sort of a project management spreadsheet that I have almost all of the functionality and layout I need, but I can't quite get one last thing to work. What I want ...
I have an App_SheetChange event included in the ThisWorkbook object of my add-in so that I can detect when cells change and perform some cell formatting. However, this event handler also trap...
Hi there,
Please can someone check this code for me I am getting an overflow error with the variable 'sDateCellCount' = 32767.
'DateRange' variable = $A:$A i.e. column A
I'm just tryi...
Hello, I would like to use an Office Web Components (OWC) spreadsheet on my document. I would like to add it using VBA. Can you help me, Thanks
Hi,
I'm using powerpoint 2000 and I have inserted an excel bar graph into one of the slides. This graph gets updated with a new record every 30 minutes. The first column from the excel sheet...
