cells5

Hi all, I try to find the code that would allow me to put the values of a listbox from a userform in one cell of an excel sheet. Below For b = 0 To ListBox2.ListCount - 1 With Cells(5, 24) .Value = ListBox2.List(b) End With Next Or Dim arrItems() Dim cnt As Long Dim I As Long...

Hi all, Im looking to convert the formulas in some cells to values and then revert back to formulas? Basically i have a save button that saves the file but i want the data to become static in the saved file some cells do have formulas that need to stay because they are looking at the now...

I have a dynamic formula and it is working just fine, however I want it to be converted to R1C1 formula. Can you please help me with this? Cells(5, 7).Formula = "=VLOOKUP(F5,'[" & Range("A1").Value & "]Job Tracker'!$E$1:$F$" & a & ",2,0)"

Can anyone help me with the bold code that is a type mismatch below? Sub Promise_Date_Change_Detector() Application.ScreenUpdating = True Dim WB As Workbook, WS As Worksheet Dim c As Variant Set fso = CreateObject("Scripting.FileSystemObject") Set fldr = fso.GetFolder("U:\Public\All Customer...

Trying to loop through multiple files in a folder. Keep getting run time error 13 type mismatch on the bold below. Can anyone help? Sub Promise_Date_Change_Detector() Dim WB As Workbook, WS As Worksheets Set fso = CreateObject("Scripting.FileSystemObject") Set fldr =...

I have a Sub that I had to split up into 12 Subs because of the 64k limit and an hugely expanded product list. Each Sub does exactly the same thing just in smaller chunks than before. When this was a single Sub, the user was prompted to enter a product name which then populated a column and was...

All cells are formatted as "General". Range(Cells(1, 1), Cells(5, 5)) all contain a 2. Getting type mismatch error - see "Watch" at bottom. Declared in a module: Option Explicit Public OldData As Variant Public Newdata As Variant Public TmpData As Variant Worksheet: Option Explicit Private...

Hi all, The format of the dates that I'm using are different although I both formatted them in the same way. I copied them to a cell in my workbook and the date that is visible in the cell and the date that is visible in the inputbox above the workbook stay different. It's like super...