.name

IF I add a user form, I can change default form name from UserForm1 to whatever I'd like; lets say I rename it to u1 Lets say I create a userform click event that states: MsgBox Me.Name That will work and msgbox will return 'u1' My problem is with a function that I created, where I have...

I have a pivot table based on a SQL query of transactions. the pivot table summarizes sales activity by unit producing a two year history by item and customer. There are three calculated columns that are repeated for each month and then a yearly set. Of interest here is the current year total...

Hi Folks, Hope you can help. I have a userform that uses an inkpicture object named "Signature_Pad" to obtain the users signature and place it on an excel sheet. The userform opens when a user selects one of the Named Ranges I have created (4 in total), using Worksheet_SelectionChange. I have...

Is there a limit to the SUMPRODUCT? This fails: Dim LastRow as Integer LastRow = 1000 Dim a As Variant With Sheet1 a = Evaluate("=SUMPRODUCT((-1*('" & .Name & "'!AN2:AN" & LastRow & "+'" & .Name & "'!AR2:AR" & LastRow & ")/'" & .Name & "'!H2:H" & LastRow & "/12<=" &...

Hey Expert's When i run following code then all optionsbut's link to cell B14 what the heck is going on thanks for any help :-) Sub AddOptionButton() ActiveSheet.DrawingObjects.Delete For Each c In Range("B3:B14") c.Select With ActiveSheet.OptionButtons.Add(Selection.Left, Selection.Top...

Hello, I would like to see if it is possible to control the addition of Labels and text boxes based on a button click to my multipage object on my form. My initial thought was to use a case statement that would count the button clicks and add the labels and text boxes as needed. However, if I...

Fellow sufferers! I wish to adjust a graph so that the y-axis is only just long enough to accomodate . Also, the physical distance on the screen from 0 to 1 mark shall be fixed. The .Height = adjusts the height of the graph itself. I need to adjust the y-axis (and consequently the height of...

Hi, I have a loop inside a Sub that copies and pastes values and cell names into a new workbook. Randomly, the loop stopped working. I haven't adjusted this code or any of the cells that it's looking at, so it's very strange. It's causing the Object error 1004. The code is below and I've...

Hi all, I have a line of code that is generating the below response. Range("F" & nrow, "F" & llr).Name = Header(iii) Error: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans...