Programming

Finicky EssVRetrieve
I've been using VBA to retrieve Essbase data into an Excel report for quite awhile with no problems. I recently added some members to the existing report, and the report no longer updates via VBA. I can, however, update the report by selecting Essbase/Retrieve directly from the menu, so I believe the report s... 16 Dec 2009 16:52

How to do check for factors in formulas?
I need help creating a function. The goal is to parse formulas from cells A1 to A5 and find the values of each factor. Example: A1 - "A+B=CD" A2 - "C+D+E=A" *Notice the double digit in the first formula. In this example the macro needs to parse these two rows and find the values for A,B,C,D and E that satis... 13 Jan 2010 00:03

Number Format. Switch Comma to Dot
Hello, I have the following number in a cell: 12,892.70 This is recognized as text. I tried to change the cell format to number and it does not work. The format should be 12.892,70. Is there a way to make this change on the Sheet instead of VB? Thanks, Miguel ... 15 Dec 2009 21:11

visual c# excel 2007 pivot filter
Hi, I'm trying to add pivot filter with multiple values checked using visual c# 2008, we tried using the xldatebetween syntax property of the pivot function, but keep getting an error on the object data property. Can someone please guide me to the right syntax below is the string from the code tablePage... 15 Dec 2009 17:51

How do i select the coordinates of the first column & last row in a pasted range
When i have a range pasted to a worksheet, how do i retrieve the coordinates of the last row, first column of this range (the range contains empty cells). Example of a range : B3:F32 => the result shuld be B32 The range is not fixed, it could contain 1 row to ..... rows PS : The range is pasted and selected ... 15 Dec 2009 15:37

Restrict cells selected to specific range name
HI, I would like to restrict selection of cells to only a range say the dimensions of a range name. Is this possibly in VBA please. EG My rangename is Weeks which is the range A1:B10 and i dont want any users to access cells outside of this range. Hope that makes sense. Thanks JB ... 15 Dec 2009 10:04

Strange thing when copying a range !!
The following code gives me the error " 1004 ..." in the second line Sheets ("MASTER").Select Range("Fall_from_height").Select 'PS : the range exists !! Copy The following code works, but after the Copy instruction it creates an new workbook !!!!! (i do not want that it creates a new workbook). Sheets... 15 Dec 2009 23:22

Some help with a workbook please
Hello any assistance provided is greatly appreciated. I would like to write a formula, or code where I can have cell c15 on sheet A equal cell A1 on sheet B if Cell B1 = incorrect and cell c2 = 5164. So more exactly: If b2=incorrect and c2=5164 then copy a1 from sheet dec to sheet corporate c5 The part t... 10 Dec 2009 20:07

ModifyAppliesToRange
I've posted this in a few places, but am not getting any traction, so here is another post. =D I'm attempting to create a relatively simple Excel Add In. I have the basics working, but now I'm attempting to iterate through the existing Format Conditions and show a message box with the AppliesTo range. All I... 9 Dec 2009 18:54

Syntax of Commands Created by Macro Recording (VB_VarUserMemId)
Hi All, In case you are also having this issue, the solution is here: http://www.keyongtech.com/5265319-extraneous-data-in-macro-recorder Gennie "Gennie" wrote: Hi Experts, I need your help. I have recorded a macro to format cells with borders. Please see below the corresponding commands... 8 Dec 2009 11:57