1. P

    Expiration date formula in large spreadsheet; avoiding Data Model

    Hello all. I have a fairly large data set (30,000 lines -will grow to 50,000) which is a set of employee payroll records. I am hoping to identify a particular type of rule violation - when a worker who has worked both as a "Temp" and as a "Part-Time" has worked hours in violation of the rule...
  2. P

    Adding Numbers with Text in Cell

    So I'm trying to add a row of cells that contain both letters and numbers. I'm using the following macros: Function add_num(cell1, ParamArray Arr() As Variant) Dim temp As Double For i = LBound(Arr) To UBound(Arr) temp = temp + GetNumber(Arr(i)) Next add_num =...
  3. J

    Date loop

    Hello: I need a sub to input last month's date into a column of data and then hard code the date. The only solution I came up with is below, but I'm wondering why it's not creating a circular reference. Thank you! I'm sure it has something to do with equivalency, but I'm still new! Sub temp()...
  4. M

    How to display these combinations

    <colgroup><col span="2"><col span="2"></colgroup><tbody> 0 0 0 0 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 5 5 5 5 6 6 6 6 7 7 7 7 8 8 8 8 9 9 9 9 </tbody> Code: Function ListPermut(num As Integer) 'Permutations without repetition Dim c As Long, r As Long, p As Long Dim rng() As...
  5. M

    VBA Loop until finding a match from temp data from SQL pull

    So I am currently working a project and I and I need to create verify text given through an input box against an SQL result. If the number "15" is entered and the sql table contains 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 I need it to save the number variable if a match is found and if not I need...
  6. J

    Poisson Data by Long Method - UDF Error?

    I am trying to convert a C language code to VBA. The converted VBA UDF code is: Public Function Poisson2( _ Optional ByVal C As Double = 4) As Long If C <= 0# Then Exit Function Dim d As Double, beta As Double, alpha As Double, k As Double, u As Double, v As Double, x As...
  7. M

    Copy data from a closed workbook and paste it in a specific sheet of an open workbook

    Good day all, This is my first post and I am looking for some help with VBA. I am new to coding and macros so what I have below has been copied from other posts on this site but it does't seem to work as I had hoped. Desired function: I have a Macro Enabled Template workbook, "MODIFICATION...
  8. B

    New position

    After a year as a temp (it was supposed to be 2 months) I am moving on, going back to Purchasing, this time at a Level ! Trauma Center. The project I did and re did and re did is now ready for prime time. To all the wonderful folks who answered my questions and showed me the way, thank you from...
  9. L

    for loop question

    Hi I made a spelling mistake in the code below but still working fine. the currentpostion in the loop For x = currentpostion To Len(phrase) is wrong spelling. I stepped in the code and it is always 0. However, the code worked fine. Why is that? Thank you Sub onlynumber() Dim phrase As...
  10. L

    Extract Numerical Portion of String

    Hi I am trying to understand the code below. I have 2 questions now 1) What is the idea of using Mid() function 2) What does &amp mean. Temp=Temp&amp;Mid(Phrase,Current_Pos,1) Function Extract_Number_from_Text(Phrase As String) As Double Dim Length_of_String As Integer Dim Current_Pos As...
  11. S

    Downloading code bogging excel

    I have some code that downloads pdf sheets at hte push of a button. The code works like a champ but (I presume because my internet connection is beyond super slow (satellite, 0.34mbps download....), excel goes into a "not responding" mode until the download completes. Is there any way to fix...
  12. S

    how to reference the same row

    If I have this piece of code to reference each row in a continuing loop, how would I write to reference just the same row for which the button was hit (i.e. if a button was over cell a1, then it would run the code for a the row 1, but if the same code was run for a button in a4, it would run the...
  13. S

    changing from every row to static

    I'd like to change the following code so that instead of going every row, it will allow the button on that row to run the code for just that row (if this makes sense). Basically I have two macros- one that checks every row (in a certain column) for data and if something is there, makes a button...
  14. S

    Failing to Find File

    So my code was working perfectly last week (when it ran for the first time. Now it says it can't find the "temp" folder that it created....and I see the folder on teh desktop. It's bugging out at the "Kill (TempFolderOLD) line. Ideas? Sub Downloadx()Dim URL As String Dim tstamp As String Dim...
  15. S

    VBA Download/Updater

    With a little help, I've written some code. The intention of this is to perform weekly updates of a downloadable file. This macro, if it works, will be copied over and over (unless someone has a better way, PLEASE!) so that roughly 25 different files can be downloaded individually and/or...
  16. M

    Subscript out of range error

    Hi Everyone I have a code that suppose to make the combobox in the userform searchable found this code in the internet but the subscript error out of range occurred. I already changed the worksheet name to the existing worksheet but still there is an error. can anyone please help me resolved the...
  17. B

    Create Temp Copy of Workbook to Email (Ron De Bruin Code) - TempFilePath Environ Issue

    Hi Community, Hoping you can help with an error i'm encountering when running a script to create a temporary copy of the workbook > attach it to email and send using outlook. I get an error on: TempFilePath = Environ$("temp") & "" The exact error message is: "Compile Error Can't Find project...
  18. J

    Help with macro

    Hi, I have the following macro that copies the master sheet and adds a sequential number every time its run. I also need it to replicate the sheet number in cell S13. My macro works but for some reason the sheet numbers change after i insert the second sheet. The worksheet numbers represent the...
  19. M

    Using MacScript to run a line of code in Terminal through VBA

    I've made a workbook in Excel for Windows, and am now trying to get it to work on Excel for Mac. One option I have given the user is to output certain sheets into a single PDF file. Due to a problem with Excel for Mac, I've had to write code to output each worksheet as a separate PDF file. I...
  20. O

    return value based on lookup of two criteria

    How can I add to this formula to find the closest result in my temp. column? If I enter an exact temperature it will return the correct result. Ex: -17.56 = 1.11759 My formula is: =INDEX(C2:C8, MATCH(G2&G3, A2:A8&B2:B8, 0)) Any help would be appreciated...

Watch MrExcel Video

This Week's Hot Topics

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