errors

I have tried the Me.Date_Picker.Value = Value in both worksheet start, userform.intialize tried the Now() with no luck. I have googled this and tried everyway but i keep getting errors....

Hey all, I am creating my first vba code which will help me a lot at work. The aim of this vba code to convert excel file with many formulas, sheets and data into an excel file ready to send to the client - without only two sheets, less data and formulas. This code will help me to save a lot of...

I am relatively new to VBA, which I've been using to solve basic problems and automate reasonably complex tasks for my workplace. My most complex one (so far!) is actually two documents: a data source housed in Excel and then the merge letter in Word. Rigging the Word document to do what I want...

I am having a very odd problem with Excel 365 Pro+ formula results. I have a complex cash flow modeling worksheet that includes 100+ columns of data in weekly buckets. The formulas in each column are circular/iterative and solve to a minimum cash balance, with the revolver paydown/drawdown...

Hi I want to stock my range (lets say A6:A13) in to a variable. But the size of this range can change according to what the user puts in. Later on I will take this variable, transpose it and paste it in the range A1:Z40 The code I have is: Sub AuswahlErstellt() Dim Proben() As Variant...

Hi so what I am trying to do below is just add another tab, but I need to always add a tab and it to be second from first. I have 15 tabs so I always want to add a new one as second tab and name it Errors. I tried worksheets (2) but debug. Sub Macro3() ' Sheets.Add After:=ActiveSheet...

I am looking for something similar to below, except for only "RS" and "CF" I also want to add "DC" and "TS" as more options. I tried adding it as criteria 3 and 4 using the previous format, but only got errors. Thanks for the help! Sub DeleteProducts() ' ' DeleteProducts Macro ' ' Keyboard...

Hello. I've searched all over and tried everything I've found to come up with a formula for the following: I have a master sheet with 200 or so User IDs, months of the year, and production data (the chart below is just a small sample). I want to be able to enter a User ID in cell B10 and a...

Hi, I'm attaching a copy of the sheet I have. The VBA code which I've annotated as best I can gives me errors every time a cell is changed. Also the age errors don't work after like row 20 or something. Could someone help me please? I'm still a relative newbie with VBA...

Hey all, getting N/A errors for some reason. =IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=1,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p> IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=2,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p>...

I am trying to do a SUMPRODUCT calculation which avoids bothempty cells and error refs, without success, can anyone offer a solution please? The range of cells I am trying to add contains both text andnumbers and I am trying to sum the total number of different values ie. A...

I have been using the following to sum the number of valuesin a list without counting the same value twice and ignoring any cells wherethere is no data. =SUMPRODUCT(($V$17:$V$40<>"")/COUNTIF($V$17:$V$40,$V$17:$V$40&"")) This works fine, but in some cells I could have errors ie#VALUE! and...

I'm trying to sum columns/rows with multiple criteria using sumifs and sumproduct, but get value errors. My data table looks like this: <tbody> 1000 2000 3000 Total 1000 # Emp# Salaries Bonuses Pension Total Salaries Ben A 121 1568.98 500.00 (29.65) 2039.33 150.00 0.00 </tbody> My...

Evening Looking to Count errors in Column F. My attempt below. Sub countErrors() Dim lastRow As Long lastRow = Range("F" & Rows.Count).End(xlUp).Row Cells(1, 14) = Application.WorksheetFunction.Count. _ Range("F2:F" & lastRow).SpecialCells(xlCellTypeFormulas, xlErrors) End Sub

I'm trying to get a text box on a user form to look up a value in a combobox on the user form...then populate itself with the value it finds. I'm trying to use Application.Worksheet Private Sub TextBox1_Change() With Me .Reg1 = Application.WorksheetFunction.VLookup(CLng(Me.Reg1)...

I have Make Table query that evaluates a field, replaces an undesired character ("*") with another ("_"). The replace function within the calculated field works correctly, however errors appear in the results. This creates problems down the line. Is it possible to somehow exclude the errors...

Noticing some issues lately; wondering if anyone else noticed. Previously, I could load a user form project, leave it up and running overnight (forget to close it) and arrive back the next day and still be able to use the form and it's controls. Now what I'm noticing, is when a period of time...

Not sure if this is possible. I have 40,000 rows, and using EasyXL, I split my list by Body Code. Column S has the value for that row, but not every row is error-free, to be fixed later. Because of the errors, i am using AGGREGATE(9,6,S1:S2000) to sum the rows without errors. But i have an...

Hello! It's my first time here and I'm looking for help. I have this formula: =IF(and(J8<$X$8, J8>=$W$8, $Y$8, IF(AND(J8<$X$9, J8>=$W$9, $Y$9, IF(AND(J8<$X$10, J8>=$W$10, $Y$10, IF(AND(J8<$X$11, J8>=$W$11, $Y$11, IF(AND(J8<$X$12, J8>=$W$12, $Y$12, IF(AND(J8<$X$13, J8>=$W$13, $Y$13...

Good Morning everyone. I'm trying to do make cells B2 and B3 light up red if MAX(B2,B3)-MIN(B2,B3)=>0.003 I keep getting errors when I try to enter this in conditional formatting. Please help and thanks in advance.