dte

  1. B

    help with dates in VBA

    I'm relativity new to VBA. I am hopeful someone can help me with the below macro. The Macro takes a day of the week like Monday or Tuesday and converts it to a real date based on whats imputed. It works the way I want other than, I need it to be formatted as a 2 digit month 2 digit day and 4...
  2. L

    Summing up reference a date

    I have a worksheet that has almost 500,000 lines of data. I want to sum up all the data for each day. My dates are stored in the format dd/mm/yyyy and are in column M, my values to be summed up are in column H... and my output should show in column N... My code so far doesn't seem to work...
  3. C

    Loop code

    I'm a complete novice at this, but have stumbled through up until this hiccup. Trying to create code to check each cell in a column and if there is data in the cell, convert the data to a US date (currently coming in as text and European format). I got the date code to work in a different macro...
  4. S

    Subscript of our range

    Hi, Im writing some code to calculate daily, monthly and annual realised volatlity. ( I know i can do this with stdev but for what i want to use it for i want a manual calc.) I keep getting "subscript out of range" error once it goes beyond my last cell in the monthly calcluation Any ideas...

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