type

I came across this VBA post that allows me to create an email and BCC a list of emails, however I want to gather the visible filtered list, and not everything that is within the range. I'm unsure where SpecialCells(xlCellTypeVisible) would apply. Any assistance would be appreciated: Sub...

Hi, I have a number of lists with various versions of same items but want to count key parts of text within cell. For example: Column A Back bacon Smoked bacon Rindless bacon I would use countif(A:A,"*bacon*") to return the value 3. However I want to take this a step further and have a cell...

Hi The code below worsk but I wonder why vBA does not have Time type. Is not Date and Time format different? I defined x here as a Date but then assign Time function to it. It did work but wondering why there is not Time type. Thank you very much Sub mytime() Dim xtime As Date xtime =...

Hi all, We're spitballing some ideas at work and want to see a map of our customer journeys. We have 19 different product types and want to see how they travel from one product type to another, or stay within the same product type each booking. I have no idea how to present this data in a...

Im trying to create a worksheet for tracking time and am having a little trouble with how I enter the time.. Simply I enter the start time in C3 and the end time in D3 and E3 (formula in E3= =D3-C3-0.5/24) shows the elapsed time. Is it possible to customize the way I enter the date like the...

Morning, I have merged two codes together but the seocnd part of the code does not execute / run I press my PRINT 1 INVOICE BUTTON on my worksheet. The invoice is then printed. I see the msgbox CLEAR INVOICE AFTER PRINTING. I press the OK button but after the msgbox is closed then this is...

Hi I tried to google this but do not know the name of the list. When I type Workbooks(1) for example and then the dot, I will get a list of all methods etc. What this list called? How I can control it. I mean if it was not there, can I go to settings and enable it? Thank you very much.

I have made a drop down list that is searchable using formulas and it works. However if i type in 2x4 it gives me certain items. If i type in 2 x 4 with spaces it gives me different items. =IFERROR(VLOOKUP(ROWS($I$2:I2),$C$2:$D$3799,2,0),"") this one looks to see if there is text from what is...

so i have in column A...booking point...and under that...x376x, x324x.... in column B, i have product type....under that, TR Swap for whatever reason, when i pull this data in using a vba macro based on the criteria above, it's also pulling in booking point "x324xVAL," but i dont want that...i...

Hi Everyone, I've been playing around with activex text boxes and have found I can adjust the height as I type. so what I would like is a bit of code that can adjust the textbox to one line bigger (or the size of the text i'm tying in I have this bit of code that will resize the text box so I...

I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I try to use it in a query: Expression.Error: We cannot convert a value of type Function to type...

Hi, Hoping Toadstool will see this as he knows the history of what I have been trying to do. But if anyone can help I would be so grateful. I am doing timesheets and have formulas in now that work for adding hours over multiple rows and then multiplying it by 1.5 and 2. What I need now is...

I have a textbox that has the text "Please type notes here" and a button that prints to pdf. If no notes are written in the textbox, a blank text box with the text "Please type notes here" will still appear when I print to pdf. How do I make the text box invisible if it contains the text "Please...

I've read several posts about how to use autofilter with more than 2 criteria and the answer seems to be to use an array - I am trying the following but get a Type Mismatch error on the Criteria 2 line? Criteria1 = "*Meeting 1*" Criteria2 = Array("<>*at their Stand*", "<>*Table...

hi is there a way through an excel vba to disable the refresh button in excel for a power pivot table or any type of refresh ? i don't want to protect the sheet i just want to disable refreshing it (with a password)

Hello, Let's say rng1 is some range like A1:A10, and rng2 is some range like B1:B10. I am trying to do the Application.WorksheetFunction.Sumproduct and it is giving me a type mismatch. I have: Application.WorksheetFunction.SumProduct(--(rng1 > 0), rng1, rng2) I only want to sumproduct...

H All, I’ve broken my brain on excel and need assistance….. I’ve built a doc to help me calculate the number of staff working by 15 minute interval per day of the week. I have around 50 staff but they all work different days & hours in the day. I seem to be having issues at certain times of...

Sub test() Dim textVAR(0 To 5) As String Dim i as Long textVAR(0) = "Do" textVAR(1) = "Re" textVAR(2) = "Me" textVAR(3) = "Fa" textVAR(4) = "So" textVAR(5) = "La" For i = LBound(textVAR) To UBound(textVAR) If textVAR = "Do" Then msgbox textVAR Else msgbox "Nope" End If next i End Sub if i...

anyone have an experience with offset returning a wrong data type error when increasing the height above 1? =OFFSET(A1,0,0,1,1) works just fine. =OFFSET(A1,0,0,2,1) produces wrong data type. Starting with a different reference doesn't seem to make a difference.

Here is my data: Col A Col B Col D Col E <tbody> 01/01/2010 a 31/12/2009 a 02/01/2010 b 01/01/2010 b 03/01/2010 c 02/01/2010 c 04/01/2010 d 03/01/2010 d </tbody> In cell G1, I type: =MATCH(1,(B1=E1:E4)*(A1<=WORKDAY(D1:D4,3)),0)...