enddate

Hi Everyone, Here i am trying to count number of weekends that are available in a particular month excluding 2nd and 4th Saturday I have the below code to check all the Saturdays and Sundays that are available between two dates but i need to exclude 2nd and 4th Saturday between those two given...

Can anyone help me please? I’m new to VBA and I’ve written code to run an AutoFilter. It’s only a few lines and I should be able to see what the error is but just cant. It runs and it shows the headings and deletes the rest of the range. Sub StartEnd() Dim StDate As Long: StDate = (AO1) Dim...

Hi All I have been getting some code together which looks at a data tab;e and extracts between 2 date ranges. My issue is the data in the rawdata is in DDMMYYYY - when the msgbox pops up and dates are entered the search results revert the dates its searching for to MMDDYYYY. Any ideas on how...

I have VBA code which retrieves historical stock prices data for the last number of periods (days, weeks or months) up to the endDate specified by the user in the workbook. If I try to download data for more than 100 shares at a time, the speed of download progressively decreases. The only...

I've been troubleshooting and running this code for a while now with no trouble on the line that is giving an error now. The line below is returning an "method hastitle of object chart failed" error and I'm not sure why? Any ideas what could be causing this? .HasTitle = True within the...

I am having trouble producing charts in VBA. I am having trouble with the portion in the With statement. I was receiving an error "Unable to get the chartobjects property of the worksheet class" on the line: With Worksheets("LowDistCharts").ChartObjects(aa) The properties I would like to add...

Hi all I'm having an issue with a piece of code that's designed to seach for a date in another workbook, copy the data next to that date and paste it next to the corresponding date in ThisWorkbook. Since this code will be run daily, but the data from the source file is liable to change from...

Hi all, I have an error with these lines of code: Dim StartDate as Date, EndDate as Date StartDate = InputBox("") EndDate = InputBox("") ActiveSheet.PivotTables("xLabor").PivotField("CSVFile].[Account].[Account]".PivotFilters.Add2 , xlDateBetween, Value1:=StartDate, Value2:=EndDAte...

I used the Macro Recorder to get the basics, added in for Criteria1 and Criteria2... All worked good till I needed to select certain rows and available cells... Here is the code I am using with all the "Failures" for selecting the ranges.. Application.ScreenUpdating = False Dim Startdate...

Hello, i want to filter the data between Date - 3 to Date +3, i am trying to format the date in code but not working, it return no result. Here is my expected result: https://imgur.com/a/83jTSTX Please help me. Thank you very much. Private Sub CommandButton17_Click() Dim today, startdate...

Hi, I have the next VBA code that filtered between two dates. I wander how can I modify it to bring me also the "(blank)" cells that I have ( I need them too). Sub filter_24() Dim StartDate As Date, EndDate As Date StartDate = DateAdd("h", "-16", Date) EndDate = DateAdd("h", "8"...

Hi All, I'm working on a macro whereby I'd like it to function between two dates, respectfully. And pop an Msgbox, if it falls outside of these two dates. startDate = "15/01/2015" endDate = "25/03/2015" I've picked these dates as a test. I have this posted at the top before my code...

Hello I have created a userform that allows users to filter a worksheet. But I can not get the filter to work for the month and for the blanks I have this so far: Filter month (combobox2 = month name) Dim startDate As Long Dim endDate As Long startDate...

Hi All I have read a few forums but I am now stumped and hope some one can help me I have managed to create the pivot table using VBA and I can filter the rows and columns in the table but I cant filter the date range required Not sure how to add Sample data but I have the following fields with...