Search results

Works perfectly!!! Thanks so much!!!

Thanks. I'm trying to create a calculated column. I tried your suggestion but it only returned BLANK. Should I use something besides "xxxx" at the end of the formula? I removed the "xxxx" and it returned the largest number in the whole table for col 3.

Hello, I'm trying to calculate the maximum number in one column (Col 3) based on the common values in another column (Col 1). Example given. Thanks for your help.

It works!!!! Thanks Kyle - You Da Man:cool:

Luke, thanks for the suggestion. I tried it but got an error that a circular dependency was detected. Even without the error, I don't think counting the blank etnries would work since I have quite a few and would have resulted in a negative number.

Hi, I have a a column in powerpivot where I want to count the number of distinct entries but exclude entries that are blank in the count. The formula in the calculated field is: UniqueIDProcessID Records:=DISTINCTCOUNT([UniqueIDProcessID]) For example: I know I have three unique records given...

Got it figured out!! I had other routines that included: "Application.EnableEvents = False" without ending the routine with "Application.EnableEvents = True" I added the following to each sheet that included the button that I needed to make named command buttons visible/invisible and...

Narayan, Thanks. The file you sent works exactly as I expected. The button becomes visible/invisible as soon as I change the value in e13. However, once I open my file, your file no longer works. Even when I close my fiel, yours still doesn't work. I have to completely exit excel and...

Narayan, I've tried this: Private Sub Worksheet_Activate() 'ActiveX button If Range("e13").Value = 0 Then Sheets("RA NE").ViewRA_NE_GT_2_Days.Visible = False Else Sheets("RA NE").ViewRA_NE_GT_2_Days.Visible = True End If End Sub However, when I go to the "RA NE" sheet where the value of...

Thanks it works perfectly . . . but only when I manually run the code. How do I get it to run when the user goes to that sheet? Thanks again. Almost there.

Hello, I have a command button on an excel sheet that I want to make visible / invisible based on the results of a formula or value of a cell. How would I do this in VBA? Thanks!

Hello, I keep getting the following error: "ERROR - CALCULATION ABORTED: MdxScript(Sandbox) (6, 61) The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String." I'm trying to create a PowerPivot using data from a table with the...

Still looking for help with my userform display. It looks like the last link worked according to Narayank991. Thanks

Hopefully, third time is a charm! I hink the previous link did not include the "131" at then end when you cliked on the link. https://skydrive.live.com/?cid=fe046114d24ad196&id=FE046114D24AD196%21131

Sorry about that. Try this: https://skydrive.live.com/redir?resid=FE046114D24AD196!131

SirJB7 and others, Thanks for all your help. Still searching for a solution. Here's a link to a "shell" file that should have. I hope this helps...

SirJB7, Thanks. The spreadsheet/userform I'm using has a lot of proprietary info so I can't upload a sample file that would illustrate the problem I'm having. Is there a way to upload the image as a jpeg? As far as the method - I'm using the Show & Hide method for the userform. Regards,

Hello, I have a problem that is difficult to explain without having the actual form in front of you but here goes . . . I have a user form with checkboxes (I'll call them parent checkboxes)that activates and or displays other textboxes (child textboxes) and/or checkboxes (child checkboxes)...

I have a UserForm with 5 columns and 3 checkboxes in each column. The user can only check 1 of the three check boxes in each column. What VBA code would I use to manage this part of the form. I have use the following when the user can only select one checkbox or the other: Private Sub...

I'm looking for VBA code to have TextBoxes maintain the formatting that the ControlSource has on the actual spreadsheet. I've searched throughout Chandoo but haven't been able to find any VBA code or if there are properties on the TextBox that will do this. Thanks Thomas

Luke, Works like a charm! Thanks

I have a number of users of a workbook that contains a number of pivot tables. When the user views the data behind the table, a new sheet is displayed. I know its not difficult to simply delete the new sheet, but you don't understand my users. Therefore, I'd like to have code that deletes ALL...

Got it!! Cells.Replace What:="File_Name_Placeholder", Replacement:= _ Worksheets("Sheet1").Range("$B$3").Value, LookAt:=xlPart, SearchOrder:=xlByRows, _ MatchCase:=False _ , SearchFormat:=False, ReplaceFormat:=False This does the seach and replace in all sheets. Thanks Hui for pointing...

Hui, Thanks! The script works but only for one cell at a time (i.e., I have to keep running the macro.) What do I need to change to have it change all of the references on 4 different sheets? Thomas

Hi. I'm trying to figure out how to find & replace "File_Name_Placeholder" in all formulas contained in the workbook with the actual file name entered by the user in Sheet1: $B$3 For example: The user enters the file name: abcsheet.xlsx in cell $B$3 on Sheet1 In cell $B$3 on Sheet2 is the...