cellsy

  1. S

    Converting date from cell to month as mmm VBA

    Hi, I've got dates in column A in dd/mm/yyyy format and I need to extract the month number in mmm format in column H vba. I've used the following code to get the date into column H but cannot get it in mmm format. The reason I need to do this is each month bank statement data will be pasted...
  2. 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 =...
  3. A

    Access upload date format

    Hi All The problem i have is. i have created an excel file with a userform that is a questionnaire. with in this questionnaire are several section where a date is required. once the userform is submitted a worksheet has cells filled in with the userform values. no problems here the problem...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top