thismonth

  1. A

    Vlookup in VBA errors

    I am trying to run a Vlookup inside a VBA. I am trying to run a dynamic Vlookup with two changing variables that will pull the needed data with the other workbooks closed. The two changing variables are Month and Year. If there is a better way to do this I am open to suggestions. I am new at...
  2. W

    Macro Error

    I have been running this Macro for a while and all was good until my computer was upgraded to windows 10. My excel is now Excel 365 2016. The debugger highlights the row I put in red. Any help with this would be great. Sub CopyData_Machine_Performance() Application.ScreenUpdating = False...
  3. W

    Why 1004 Run Time error at Red Text?

    Sub CopyData_Machine_Performance() Application.ScreenUpdating = False Dim lastRow As Long lastRow = Sheets("DATADump").Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Dim ldateto As Long Dim ldatefrom As Long Dim ThisMonth As Long Dim ThisYear...
  4. A

    Copy from range

    HI!!! Sub getSum() Dim strDate As String Dim ws As Worksheet strDate = InputBox("Insert date in format mm/yyyy", "User date", Format(Now(), "mm/yyyy")) If IsDate(strDate) Then strDate = Format(CDate(strDate), "mm/yyyy") Else MsgBox "Wrong date format. Please try again." Exit Sub End If Dim...
  5. A

    Sum a range based on other range criteria for all sheets

    Hi!!!! Sub getSum() Dim strDate As String Dim ws As Worksheet strDate = InputBox("Insert date in format mm/yyyy", "User date", Format(Now(), "mm/yyyy")) If IsDate(strDate) Then strDate = Format(CDate(strDate), "mm/yyyy") Else MsgBox "Wrong date format. Please try again." Exit Sub End If Dim...
  6. A

    Sum the Total value of a certain range with date for whole workbook

    Hi!!!! My workbook contains more that 1000 sheets and increases daily. I need to get total value of column "I" (Range "I7:I") for all sheets based on month in column "F" (Range "F7:F"). mumps (Member in this forum) have given me this wonderful code mentioned below which is working fine. But...

Some videos you may like

This Week's Hot Topics

Top