asy

  1. J

    UDF returning an Error

    Hi, When I am passing a range to the below UDF, say A1=CorrelationCoefficient(B1:C100, 1, 2, 0) I am getting an VALUE error. Any reason why? The code is: Public Function CorrelationCoefficient(MyArray() As Double, Optional asX As Long = -1, _ Optional...
  2. G

    Having Trouble with Deleteing Sheets

    For Each sht In ActiveWorkbook.Worksheets If sht.Visible And sht.Name = ("ASY") And sht.Name = ("TEMP") Then sht.Delete Worksheets.Add().Name = "ASY" Worksheets.Add().Name = "TEMP" Sheets("ASY").Move After:=Sheets("DATA") Sheets("TEMP").Move After:=Sheets("ASY")...
  3. G

    Copy Existing Sheet and Paste Special Values with a New Name

    Hello All, I’m having a few issues with the Code: Dim sht As Worksheet Dim ASY As Worksheet Dim DATA As Worksheet Set DATA = Sheets("DATA") DATA.Copy Selection.PasteSpecial Paste:=xlPasteValues ' After:=DATA Columns("N:N").Select Selection.AutoFilter...
  4. A

    Userform Date & Time picker

    Hello is there any way to show time value as in current time when the userform pop up?

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