Search results for query: *

Hi, I just wrote a very simple code that works on certain computers, but that triggers here above compilation errors on some others. When trying to fix the problem, it appeared that it was coming from the fact that not all the variables used were declared [ i.e even for simple loops...

Hi All, I am facing the traditional Excel Error: "Too Many Cell format". I tried to clear formats on different sheets of my workbook, but it does not seem to do anything. I was wondering if anyone knew of an add-in that could homogenise formats in a spreadsheets; or of any programmatic way to...

Hi all, The here below custom function should return me the non integer. I got the compile error: Next without for I don't understand why. Can somebody help. Thanks Seb. ===================== Function StartDep() As Double a = 0 For i = 1 To 10 YrStart = Range("flag1").Cells(1...

Hi All, - I have a model: F1 in which a macro generates a new excel file:F2, with some info. - I need this file to contain a module, so that user can perform certain task. How do I copy class/modules from F1 to F2 ? Thanks in advance. Seb

Hi All, - I have a model: F1 in which a macro generates a new excel file:F2, with some info. - I need this file to contain a module, so that user can perform certain task. How do I copy class/modules from F1 to F2 ? Thanks in advance. Seb

All, I remember to have read somewhere that it was possible to create Union of arrays. I can't figure out how to do that. Given A1 , and A2 two distinct arrays I would like to be able to do a VLOOKUP on UNION(A1, A2). Any body that could help? Thanks, Seb

Hi All, I am trying to use yearfrac function in a VBA script and I was wondering what was the proper way to call it . Any that could help. Thanks Seb =========== Sub test() a = 38500 b = 38750 c = yearfrac(a, b) MsgBox c End Sub

Hi, I am writting small macros to be linked at shortcuts to automate routines. One on them is "Paste Exact Formula". I would like to be able to paste to a range exact formula I select in another range - Basically replicate the "Paste Formulas" feature that already exist by "Paste EXACT...

Hi all, Quick question: I have a spreadsheet containing invalid ranges, I want to delete. Range names are with invalid caracters pointing at invalid references with #HREF... I tried to delete them from Inser>Name...Delete - Did not work Then I tried to list them and kill them from VBA. ---...

Hi, I am querying a table with 1! column. In this column, there are strings and number (which format is string). I want to query this table, filtering text fields and summing the numeric one. Probleme even for numbers, format is string. what built in function can i use to convert the numbers...

Hi All, I am working on a model linked to an access database. The connection with the db is working fine. some vb code is calling QueryDef("strQueryName") where "strQueryName" is probably a user defined query. When going to Data > Get External Data I cannot click on edit query. Hence I don't...

Hi all, I am trying to write a small macro to translate the content of an excel spreadsheet from german to english. Having no idea of tools I could use, I was thinking about leveraging Google translator. 1) If cell content is text - take content and post it to google translate 2) Retrieve...

Hi All, I am trying to write a small sub to switch across all my active workbook sheet, cell values with cell comments. It work in a given selection. I am struggling to run it across active cell on each of my workbook sheets. Can somebody help? Thanks --------------- Sub SwitchValueCOmment()...

I found a way to automatically generate pdf files from excel using VBA. It uses ps intermediary format to by-pass adobe prompt. I am now looking to consolidate several ps files in a single ps. This idea is to end with 1! pdf and not multiple. Any idea? Many thanks PS: For the solution I...

Hi all, Here is a formulas problem: I am a big fan of array calculations as formula. This enables me to apply multiple criteria to certain operations. =SUM(Array*IF(Array1=Cond1;1;0)*IF(Array2=Cond2;1;0)....) My problem - this gives me complexes formulas that makes difficult controls. How...

Hi all, I created a small add-in with a library of functions. Code is tested and works fine if I use it in one of my add-in sheet. Now if I change the extension of the file to xla, change the property of the file to add-in = true, and drop the file in : C:\Program Files\Microsoft...

Guys quick question - -I have a Acrobat Writer installed. -I have a print area called "PrintArea1" in a Excel workbook. -I am runing 5 different scenarios, and the content of PrintArea1 chances from 1 scen to the other. -I have a macro that makes that scenarios run (1, 2, 3,...5). I...

Hi all, Quick question related to use of forms. I converted old dialogueSheet into a form. - In the dialogueSheet: when user was input a string in an EditBox next time he was reopening the dialog the value has been recorded. - In my new form: if I type a text in a EditBox, next time I open the...

Hi, is there a method to convert a DialogSheets into a form. I am actually trying to reuse some component of a 95 Excel app. Thanks Seb

Hi, How do I hide/Unhide formulas bar from VBA? Thanks