add

  1. S

    "Add Measure" Isn't Coming Up (even after I select "Add Data to Data Model")

    I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the...
  2. C

    VBA command button to insert row at bottom of table using active.cell

    Good evening, I have a table that sometimes i might need to add a row to. I need this row to insert at the bottom of the active cell and still hold the formatting and formulas from the row above it, without the contents of the cell. I did a record macro as i got fed up trying to figure it...
  3. D

    Code to add new lines creating wrong formatting

    I have a button to add new lines to my table. The table has a date field in column A that is formatted to Australian date format. When I click the add new lines button, the new lines revert to US format for any dates that are entered in the new rows in column A. How can I force new, added rows...
  4. J

    How can I add a progress bar to a loop?

    Hi, I've never done anything before with progress bars. I have a macro which loops through a worksheet to last row and the data is used to update an external program. The problem is if there are a lot of rows (1000+) Then excel freezes up until finished. Is it possible to add a progress bar...
  5. D

    VBA Code - Add another Range to to copy and paste based on two ranges

    Hello, I have t below code and I need to add another range. For Each c In sh1.Range("AT5", sh1.Range("AT" & Rows.Count).End(xlUp)) - I want to add range ("AR5", sh1.Range("AR" & Rows.Count) Set f = sh2.Range("O:O").Find(c.Value, , xlValues, xlWhole) - I want to add range ("M:M").Find(c.Value...
  6. D

    Finding value of last cell in list

    I need to find the value of the last number in column A and add 1 to it. Can someone help me with the vba for this please? Thanks, Dave
  7. D

    Need a way of creating a reference number

    I have created spreadsheet that creates quotes successfully but my supervisor has asked me to add some sort of a reference so the quote can be identified. There is a file client_list.xlsm that has the client name added too when the quote is finalised This code will be run from my quoting...
  8. G

    Add data to dynamic range

    I have a dynamic range that expands when I add new data(naturally). I would like to add code to a button that I have that will adddata to the range when the button is pressed. This is the line of code I amworking with: Sheets("Competitor OverviewData").Range("CompetitorsLOV").Offset(1, 0).Value...
  9. S

    EXCEL is changing the formula

    The data I'm tracking is in Column G through DC or DD. I have this array formula that I establish in Column C and it covers my data through Column DY (an overkill to cover my bases). Each month I add 8 or 9 columns to the right of column DC (golf play dates) and remove the same month from Column...
  10. B

    Msgbox question

    Hello all, My msgbox is not working. Would like to show a message, show the Information icon and add values from variables in 1 msgbox; If xEptTxtName <> "" Then MsgBox "The following required fields are not complete", vbInformation & vbNewLine & xEptTxtName & vbNewLine & xTxtName...
  11. N

    Adding Data from an Excel Form

    Hello, Please I need your help with my project. I have made a system for my business and need to add some forms using different tools and entry methods The form contains: Text Box Combo Box Option Buttons Check Box Commend Button Once I open the form to add a new Item... 1- TextBox1...
  12. G

    Data Validation Error Alert

    I have data validation set up allowing a range of cells to only accept whole numbers between 0 and 100. I currently have a bland error message that pops up if the user enters data that doesn't fit the criteria. However, I want to add a picture instead of some text. Is that possible at all...
  13. sharky12345

    Add decimal point at specific position

    I'm using this to loop through a series of Textboxes on a Userform and enter a decimal point after the first 2 numbers entered; Dim ctrl As MSForms.controlFor Each ctrl In Controls If ctrl.Name Like "TextSTime*" Then If Len(ctrl.Value) = 3 Then ctrl.Value = Left(ctrl.Value, 2) & "." &...
  14. G

    Button to add column to the end of a table

    Hi, I would like to be able to assign a command button to add a new column to the end of my table. Each new column added should appear to the right of the last new column add. The command button will be on the activesheet but the table in which I am trying to add columns to will be on sheet...
  15. D

    count until "X" number appears again

    Hi Mr. Excel'ers, So, here's my problem. I have a list of numbers in Col A.. from A2 on down, and growing. I continually add numbers to the bottom of the list, so it's a growing list. I'm at A345 now. next number I add will be A346. Say for example I add number 6 to A346. Then in A347 I...
  16. C

    Add formula after index, match

    Hi friends, is it possible to add formula after index match in vba , in normal index match its working but not with vba. vba code Sub lookup() lastrow = Cells(Rows.Count, "e").End(xlUp).Row For i = 2 To lastrow Range("e" & i) = Range("b" & Application.Match(Cells(i, 4)...
  17. P

    Add Error Message To Sheet Password

    Hi, I currently use the following code to lock a sheet in a Workbook: mysheet = "Sheet1"If ActiveSheet.Name = mysheet Then ActiveSheet.Visible = False Response = InputBox("Enter password to view sheet") If Response = "Sheet1" Then Sheets(mysheet).Visible = True...
  18. I

    Calculation just doesnt add up

    Hi, I am trying to write a small basic code for fuel allowance of 45p per mile. Currently i use this which works fine & correct. =E18*0.45 But i now wish to add the cell value at E34 So i have written, =E18+E34*0.45 The value comes back as £256 but it should be £134.65 222 x 0.45P =...
  19. diddi

    Append to pdf VBA

    Morning all. I am hoping to find advice for a Shell( ) or other method to add sheets to a pdf file. I have tried several pdf generators / merging programs that support command line, but cannot get any of them to work. I have a standard sheet which is filled by VBA and saved to PDF then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top