cells5

  1. D

    Listbox values from userform in one cell in a worksheet

    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...
  2. dannyok90

    Convert Contents to Values VBA

    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...
  3. P

    Convert formula to Formula R1C1

    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)"
  4. K

    Type mismatch error

    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...
  5. K

    Loop type mismatch error

    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 =...
  6. S

    InputBox answer for multiple Sub Calls results in blank cells

    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...
  7. J

    Declaration type getting changed

    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...
  8. S

    VBA date doesn't match with date in workbook

    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...

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
Back
Top