control and shift and enter puts the formula as an array formula, when you use offset, typically an array is required, in this case, if you don't have an array {} those brackets around your formula, i don't think it will work properly.
i don't know why you get the save folder, the only thing...
I had a similar issue with that. we had to ask all possible users to restart their machines. we did the same thing you did and did not work, when we asked all parties who could possibly use the file to shut down and restart, it then worked.
first thing,
where ever your "report filter" filter is located, select the cell and give it a name. For example, cell B1 is my filter button on the pivot, i select B1 and type in the left field of the formula bar OperationSel
then add your combo box.
right click the combo box and select...
Luke,
that is the same source i previously used before coming here. thats funny. i guess my real question is, how to i declare a by value in my code? do i remove option explicit in my code?
suggestions?
I heard if I use ByVal in my procedure, for example
Sub Test(byVal X as long)
code'
end sub
that my code will be executed faster. especially if I have a lot of code to go through. Is this true, if so, how can i use it on a userform button?
thanks
try this, you need to put it in the workbook object.
open visual basic Alt+11, go to microsoft excel objects
double click "ThisWorkbook" and paste the code below.
when you put in a value and click enter it will respond.
Let me know if this works
Private Sub Workbook_SheetChange(ByVal Sh As...
yes this is correct. I tried doing a sort based off of the new order from project, but the borders do not follow any type of sort. the challenge is the gantt part of the file. the visual gantt borders wont sort with the items (new order). i did write code before to go to the new order take the...
borders are being applied to constants. for example, if work started the value is a 1, this gives me an actual start date, if the work is finished it is a 2, this gives me an actual finished date. also, when work is being performed, they click on "Working" on thier userform and it will put the...
I have a file that has a list of items. These items have a schedule. the schedule is conditionally formatted to look like a Gantt chart. This file then gets marked with a border style of when work was started and finished. If the work started a macro will put a diagonal border through the cell...
Oh, never mind, i just changed the ranges to a much smaller range and it calculates in about 9 seconds. Thanks again. you all who support us are Awesome. thanks again SirJB7.
OK, need your help again. I completed the formula for all the cells in my list needed. about 1254. the calculation time is about 5 minutes everytime i make a change. any suggestions?
sure.
i have list of part numbers. each part number is an installation that needs to be completed. a work order will be issued with the part number on it, so that, the person will know what to install. lets call the part number ABC. with work order 123. I need a spreadsheet that will track the...
due to the nature of my work, the security paramaters don't allow uploads. sorry, but i can try in here.
part number Work Order
ABC vlookup formula to find first instance
ABC vlookup formula to find second instance.
DEF 100-112
data is on network, but...
i am working on a spreadsheet that is part number based. each part number gets a work order assigned. I use Vlookup or Index/match to find the work order associated. however, sometimes they need to make a new work order and no longer use the first work order, but they need both in view and they...
I would have to absolutely agree with Hui, the business aspect is equally, if not more important than your excel skills. Because of the stigma that goes with excel, not saying i believe in the stigma, but without the business knowledge that backs up your skills, unfortunately, the value isn't as...
i am trying to compare 2 lists that should be exact. however if they are not exact, i want excel to provide a list of the mismatches. how can i do that?
Hmmmmmm.
i have been trying all day and everytime I recorded all i would get is the cell i selected and that was it. Now, i just recorded it and it worked.
go figure right!
Thanks!!!
is there a way i can just delete all on the temp sheet conditional formats and then copy the formats from the master sheet to remove all the redundants? i looked in to
Range("$A$4:$PK$800").FormatConditions.copy
but it doesn't exist. i need my conditional "applies to" field to have the...