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...

Something I found on the web: http://www.ozgrid.com/forum/archive/index.php/t-26659.html Worked for me Thanks. Seb ============================================ Sub DeleteFormats() Dim strOldFormat As String Dim strNewFormat As String Dim aCell As range Dim sht As...

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

Not Exactly the answer I was looking for - Thanks Though - What I am trying to do is replication the built in copy paste formula function; Execpt that I want tbe able to paste excact formulas. Can somebody help?

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...

Initially I copied a sheet from another workbook and then deleted it. This would normally result in invalid range pointing at #REF. Problem here is it also messed up the names, and as a result I manage to list those range but not rename, nor delete them.

Thanks - This is basically the same I tried to do. I don't have any problem to filter the range to delete. I don't have any problem to delete range with valide names even if they point to #HREF. My problem is: - I have a range with a "invalid" name - using strange caracters. I don't know...

Paul D, Thanks for the link. Very usefull tool indeed. But it doesn't work in my case. It is saying "This name is unusable" . Any other idea?

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...

concise , efficient & working - Thanks combo

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...