Thanks in advance....to anyone who provides assitance
New to VBA and I'm having issues scripting a procedure that will copy the same cells for each individual day between a predefined start d...
I would like to know if there is a way of blocking users from password protecting their excel spreadsheets. This can be done by going to Tools > Options > Security
I couldnt find anything i...
hi
i ve put the date correctly for this weeknum function but the returned value displays #name error
=weeknum("1/10/2008",1)
what is the correct way
I'm a little weak with collections, so I'm experimenting...
Say I have this:
Dim c As New Collection
Dim r As Range
Set r = Range("A1:C1")
c.Add r
That adds that range to a collect...
Hi Everyone,
I have soem code that enters in the value for a cell based on the value of another cell. For example, if the cell value equals "budget", then the cell to the right is changed...
The attached worksheet contains billing and payment information for parts of 2007 and 2008. Some of the payments are based on quarterly, semi-annual, or annual billings. I need to see the br...
I have an excel sheet that i have protected. I need to be able to see and use the autofilter and the show all commands, as they are not available with the sheet protection on. I use the auto f...
Hello,
I'm trying to pass a range of noncontinuous cells to the MATCH and OFFSET function, but excel doesn't seem to like that kind of input, and I get the #N/A error message. Is there a wa...
Hello,
I have an excel file with several sheets inside of it... to make it easier for the user I have created a combo box and lists that sheets inside and a button for them to press which t...
I have a userform that has many comboboxes and textboxes. I want the ENTER commanbutton to send the separate inputs to separate excel worksheet cells. Then I concatenate these cells into a s...
I have a workbook with many tabs, each of which has a web query. Each query has four parameters which reference an external workbook. For example, here is one of the parameters:
'M:\Corpo...
Hi,
I need to get the username of the processes running in Task Manager in an Excel macro. I am using the following code snippet to get the process name. It would be great if I was able to ...
Hi,
I have a string "W Z7 Comdty" and B1 has a formula: =BLP|M!'W Z7 Comdty,[LAST_PRICE]'
What I want to do is the replace the "W Z7 Comdty" in B1 with the reference to A1.
I tried to ...
I want to copy specific cells values from sheet to another not range , just a macro code to enable me to select specifc cells & choose where i can paste it to another sheet within the same wo...
Excel 2000
We need to sum visible cells (subtotaled data) to the end of data, and enter the TOTAL in a specific cell (O1 or Q1). This needs to be done for two different columns.
Then we ...
While navigating within the text of the text boxes in our excel spreadsheets, the left and right keys are reversed. When making a new text box and entering text, key navigation is normal. When...
I have few Pivottable using certain columns from another sheets.
When I rename a column from "RRD" to "RRD.", all the reports based on this column dont refresh anymore.
Is there a way to ens...
A user of mine recieves the follow message everytime he opens a specific Excel file: Cannot find F:\USERS\username\MISC\LBO.XLM!Auto_Open, which has been assigned to run each time "document na...
How do I remove all hyphens/dashes in a column in an excel spreadsheet without having to manually remove them one by one?
I have an "Import External Data Query" that pulls data from a MS Access database - works AWESOME! I added parameters to select data based on Name and Date entered into two cells - works AWESOM...
Need a code to read the name of all named-ranges in a workbook along with their cell range and worksheet name.
Thank you.
I have a spreadsheet that has only about 400 lines and all Data is in Column A1:A400...however I have some areas with 2 blank rows, others with 1, some with 3, etc. If you use a filter to rem...
Hi,
I'm trying to do a conditional format in excel based on the value of two columns. These are as follows:
Due Date | Result
1-Jan-2007 Complete
2-Dec-2...
I have a cube file (made by Microsoft Query from an Access 2003 database) serving pivot tables/charts in an Excel 2003 file. I want my solution to be portable, distributing copies of the .cub ...
Hi experts,
" I need to create a scheduling template upon selection of a month. This template will contain around 31 to 32 sheets. Therefore this will be a monthly template with each day of...
