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