Here's what I'm looking to do:
If RGFuture column P = < 0 in a given month, take that negative number and transfer to outgoing projections (make number +ve), adding to existing number in co...
I have a UserForm to input information of a Unit inspection on a sheet call Errors. In same workbook different sheet I made a summary of ERROS columns count, averages, etc. well this made my f...
Hi all,
I have a Macro that uses pivot table functions (olap pivot table in this case). I created it in Excel 2007, but in an xls file. However certain bits don't work in 2003. Any ideas...
Friends,
Please, does anybody know how to avoid looping using Target within Worksheet_Change?
Example:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Rang...
Installed Adobe Acrobat 4.0 on my pc whrer I use Excel 2007, and now Excel files open slowly, so I would like to get rid of the Adobe plugin but not completely uninstall Adobe Acrobat. Can I r...
see snippet code
Hi Expert
Need to re-arrange the following fromula (as shown below)
=(('Pricing Demand'!$F145 *
(1-'Shipping BOG'!$F145))
*
'Modelling (Vol)'!$F145)
to
=((...
Hi
Where would one look for information on how to create an Adobe Flash interface that will communicate with Excel in the background. For example, when I develop a tool in excel I would l...
OK,
I have one excell spreadsheet where are listed printers models. So which formula I do need to use if I want sum of specified text?
Example:
A | B
Location1 | HP 4200
...
Hi. I am trying to copy the formatting from the ActiveCell in my VSTO managed spreadsheet to another
spreadsheet but the following code fails on the last line
Globals.T...
I would like to pass a parameter, txtProjectName, to a UserForm named ABC
How can I do that?
When printing excel sheets using universe 45 font - print outs are truncated - the end of lines of text is not printed. this font works fine in all other application word, notepad etc on the m...
This has been modified since I originally posted it. The new comments are at the end.
I have just discovered that specialcells sometimes triggers the selectionchange routine.
This is ...
Hi,
Workbook in excel.(many sheets)
How can I switch between sheets use keyboard. Is any combination ? (CTRL + something, ?)
I'm building macro and if I switch by mouse doesn't work very ...
Hello-
This is a pretty simple question but for some reason I am unable to find the answer. I have a multi-column combo box with a reference 3x3 fill range A1:C3. I have the column widths...
Given: Column A & B where the similar variables repeat under column A and each of the variables have different values under column B.
Need a vlookup formulae under column F for variables gi...
I cannot seem to find a Debug toolbar. When I clilck to show all of the toolbars there are a bunch of them - but no Debug toolbar in the long list of toolbars.
I would like to be able to a...
I am using:
LastRow = .Cells(Rows.Count, 3).End(xlUp).Row
However, this finds the first empty row and thinks it is the LastRow.
So I need to find the last row either:
from the b...
how do i set Excel 2007 to be in Manual Calculation Mode at all times (not just the current workbook)?
background:
my customer has a program that is calling Excel 2007 to open workbook fil...
This is a variation on a question I asked yesterday to which I received two excellent responses and awarded points. I have a spreadsheet that lists projects in column A. Autofilter (not autoso...
Hello all!
I have a workbook_open event that turns off calculations in a particular workbook. However, I am finding that if the user has another workbook already open, this code fails to ru...
My original question can be found here:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23498498.html
So now I am looking for a method of cre...
I have an excel sheet which records fuel consumption (in Litres) by month of a fleet of cars. Is there a way to lock all of the cells prior to the current month to prevent amendments and falsi...
Hello,
I need a macro to automate an Excel spreadsheet.
I will start off with raw data in this form:
Project Topic 1
12356
56897
56235
New Topic 2
89562
45623
Third Topic of Items
...
I've searched for 30 minutes on how to make Excel scroll just one row when you move the mouse wheel. default is 3. help please.
I need a VBA script that will identify a certain Internet Explorer Window (By it's title) and then use that window to navigate to a different page.
Is there any way to do this using VBA?
