jan1 in value

This Week's Hot Topics

• Copy dates from one sheet to another in range if date is old than 11 months

  • Started by DanSMT
  • Monday at 10:39 AM
  • Replies: 36

  I am having an issue pulling dates from one workbook.sheet to another workbook.sheet. I've been working through the code. not sure if this is...
• Date and reference number being inserted into footer after the first page

  • Started by dpaton05
  • Sunday at 11:10 PM
  • Replies: 37

  How do I put things into the footer on all pages after the first using vba?
• Highlight Adjacent Cells in a grid

  • Started by JLEMS
  • May 27, 2020
  • Replies: 33

  Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get...
• Calculating lost hours per week

  • Started by gd6noob
  • May 29, 2020
  • Replies: 26

  Hi there, I have a worksheet that calculates lost hours for employees. Basically it cells AE to CD are weeks 1 to 52 and it looks at the start...
• VBA Open .txt file with a string

  • Started by ItalianPlatinum
  • May 29, 2020
  • Replies: 25

  I have a VBA code that works like a charm that displays a dialog box and allows a user to select a file. I am trying to enhance it to force the...
• Invalid qualifier

  • Started by dpaton05
  • May 26, 2020
  • Replies: 24

  I have a procedure that moves some buttons. They need to be moved to just below the bottom of the last entry in column A. I get an error saying...