myval

Hello every body, i hope that some of you guys are able to help me out. i have to get multiple excelfile into one file, but i want to make an inputbox, so that the user are able to choose between different folders. The code looks like this so far: Sub Samling() Dim FolderPath As String Dim...

Hello all Can anyone please spot my error on this code I am trying to filter on dates Greater than Today() It is applying the filter on the correct column but it's not applying the value, net result everything is filtered out Dim Myval as Date MyVal = Date FilterRange.AutoFilter field:=24...

Hello all, I am looking for a vba code that will give a input form with 2 drop boxes that will define the data to pull from a sheet that is specified. I have a workbook that covers the years down time, each sheet is a separate month. I will be required to select at the end of the month a...

What is wrong with bellow VBA code Sub TwentyfiveRandOf25ONLY6() Dim myVal As Integer myVal = Range("AT36").Value Dim i As Long Dim randIndex As Long, temp As Long For i = 1 To myVal anArray(i) = i Next i For i = 1 To myVal Randomize Do...

Using this, I can choose a file to open: Dim Selector As FileDialog Set Selector = Application.FileDialog(msoFileialogOpen) Selector.Show Dim Selected As Boolean If Selected Then Selector.Execute Dim wb As Workbook Set wb = ActiveWorkbook Dim MyVal MyVal =...