I have a workbook that consists of 28-31 worksheets, depending on the number of days in a particular month. A template is utilized to provide a new workbook for the upcoming month. The works...
I have a cell selected from previous code in my procedure and I want to insert a row above the current cell. What code would I use to do this.
I would like to import some stock information into Excel from Yahoo Finance. I envision having one workbook per stock. Let us use Best Buy (BBY) as an example. In that workbook, I will have...
Hello guys
I am googling for convertion between decimal and hex numbers and I found a lot of articles mentioning the HEX2DEC and DEC2HEX functions. I want to use them but my Excel installat...
Hi.
I'm using a macro that emulates the "advanced filter" command, so that when a button is pressed, a block of data is filtered, depending on various criteria, which is dynamic (i.e. it can...
I have a cell that depends on another formula in another cell if there is no data in the latter cell the former cell displays #VALUE!
Is there a way that I can ensure that that cell the is ...
Good afternoon,
I have used our CA to create a digital certificate to sign an Excel macro. The certificate is from a trusted CA and is set for 'Code Signing'. When I attempt to sign the mac...
Hi,
I am trying to programmatically create a pivot table to run from a macro button on a instruction page. I have attached my code. It is a recorded macro and it does not work. I recieve e...
Hello,
We are going to be getting xls's from a variety of vendors. The xls's contain product records w/ description, price, etc. Unfortunately the accounting software insists on having tx...
Hello all.
I need to count the number of characters in a cell. I say characters because the field contains numbers (formated as text, because of leading zeroes) and a dot.
So you have a...
How do I make an Excel macro automatically run every minute? , or evey hour, seconds?
I have an excel spreadsheet with about 300 lines in it, each with a hostname on it.
I want excel to do an nslookup on each host and make a cell next to the hostname the IP address that is r...
Hi experts,
I am trying to use listbox in excel, I populated the listbox with a range.
Now I wanted to make a quick filter on this listbox possible.
For that purpose I created a textbox1
...
I want to save my xls file using a custom delimter. I want to do the same thing that saving as a csv, tab-delimited, or space-delimited file does, but using an arbitrary character (or series o...
Greetings...
I'm using the formula
=IF(ISERROR(VLOOKUP(Sheet1!A2,Sheet4!B$2:B$123,1,FALSE)),"",VLOOKUP(Sheet1!A2,Sheet4!B$2:$B123,1,FALSE))
to compare columns in 2 separate worksheets...
Hi,
I would really appreciate if someone could help me solve this.
I am trying to create a macro, with which I can be able to copy the certain row and cells in multiple excel files into ...
I manage a team of workers in a call centre and I need to be able to create a progressive formula to show average handling time during the day. The problem I am encountering is that it needs ...
Related to Topic ID: 22596807
I am using the following code to find the last used row in a worksheet for the purpose of pasting a row of cell to another worksheet. The destination worksheet ...
I have a subtotal in a cell calculating the prices of some products then I want to be able to add a 6.5 percent sales tax in a formula and calculate the grand total. So cell b13 should have a...
I have a spreadsheet that imports a variety of logs from a ftp server. The spreadsheet than parses the different logs into individual sheets. Depending on the server I am importing from I ma...
Hi all,
In a sheet, I dont want few columns to be edited by users or selcted by users.
So I unlocked all the other columns except the one I didnt want to get edited, than protected the s...
Hi
I have a 10 column ListBox and want to have column headers. I have set ColumnHeads to true and then
in columnWidths have 70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt.
Ho...
I have a user that gets the following message when opening existing Excel workbooks after upgrading Office XP to 2003 Professional:
"This workbook has lost its VBA project, ActiveX controls...
Hello all,
how can I EMBED a movie file into my Excel workbook ? If I use inser object from file this works well for other file formats like doc, vsd, etc..., but NOT for movie files (f.e. av...
I cannot double click on an Excel spreadsheet and have it open. Excel starts, but not the spreadsheet. The toolbars are there but most are grayed out.
In order to get a spreadsheet open, ...
