xnpv

This Week's Hot Topics

• change colour of picture based on cell value

  • Replies: 46
  • Dec 2, 2019

  hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am...
• VBA - Combine Multiple workbooks into 1 worksheet

  • Replies: 45
  • Dec 3, 2019

  Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet...
• Last Display on userform to a Listbox

  • Replies: 35
  • Friday at 9:40 PM

  [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Vlookup and hlookup combination

  • Replies: 28
  • Dec 2, 2019

  Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the...
• Code giving run-time error when called, but not when placed on worksheet.

  • Replies: 23
  • Dec 2, 2019

  The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...
• Help with Current and highest streaks

  • Replies: 23
  • Friday at 10:52 AM

  Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...