quick

I'm trying to add to my quick access tool bar but it only seems to see macros WITHOUT arguments.

Hi, sorry about my English.. i need help about this Excel table. i want to know the total available Person of languages.. (Count) is this with index and match function? Please help !!

Hey all you smart people hoping someone can help me quick i want a vba script that selects a sheet based on cell value (sheet name = cell value) but, if the sheet does not exist, it must create it quick and easy

I've tried so many examples and ideas from this site but to no avail! It seems simple enough and I'm probably just missing something but what I'm trying to do is this: If partial text is found return true, for example: In A1 The quick brown fox jumps over the lazy dog. In A2 The user can enter...

Hi, Is it possible for vlookup to return a cell greater than x but below y. two conditions. name (a1) and number (b1) Quick and dirty example below: vlookup(a1 and b1) return test1 <tbody> Sally 750 Bill Sally Dave 0 500 501 1000 test1 1001 1500...

Hello everyone, I have quick question. If conditional formatting uses TRUE/FALSE logic (is applied only on TRUE values), and Excel takes 0 as FALSE and 1 as TRUE...what is explanation for =MOD(ROW(),3) where values are always 1,2,0...and in this case, CF will also be applied on 2... if we use...

I'm writing a macro that produces a table from external data, and I want the user to be able to format the report using a table style that they can modify. Is there a way that I can "call" the Modify Table Quick Style dialog from the macro and allow them to amend it? I know that I could create...

Hi I've just started using Xl2013. Whenever I select a range it gives an icon on the lower right to access quick analysis functions. Most of the tables I select have a total right where this icon appears so I can't see the total changing for example if I paste new formulas. Can I turn it off...

Hi guys, How do I assign an icon to a command that does not have an built-in icon ? Excel always uses the green circle and the option to Modify is grey out. I'm using excel 2010. Thanks

I have formatted cells as dd/mm/yyyy. However this does not mean the cell value itself changes, it is merely the formatting. How can I turn this formatting into the cell value itself?

Hi All, I have done all the necessary in CustomUI and the VBA; mapping the custom calls to VBA functions. Now the major pain the neck is, the small mischievous Down-Arrow BUTTON ( called as Customize Quick Access Toolbar ) on the TOP LEFT on the title bar of EXCEL, using which anyone can...

Good day everyone and thanks for the help, how do I write a formula that will change these numbers <tbody> 102080704807W400 into this <tbody> 102/08-07-048-07W4/00 These are well unit numbers and I have about 900 of them. The pattern of / and - are always the same. thanks, Lorenzo...