test1

Hello, I am a noob to VBA and macros. What I am trying to do is copy text into the middle of my formula which is a sumif formula...

Hi All I would like to convert a list of military time in Column C to regular time in a different time zone (+3hr) and also deduct 45 minutes off the new calculated time. <tbody> Scedule Title Description Time Test1 Apple 620 Test2 Banana 1050 Test3 Orange 2015 </tbody> After...

Hi Guys, I’m hoping someone can help me with this. I’m trying to find a xml node, I can find the node, however, I need to look for the node from what’s entered in a userform textbox. Here is the code I’m using: Private sub commandbutton1_click() Dim xmlObj As Object Dim singlenode As Object...

Hi Everyone, I am trying to learn the basics of VBA to automate basic repetitive work tasks. When attempting to declare variables and use them I keep getting a runtime error 438. I am sure this is a vary basic format error, but I have not found any support on how to resolve the issue. Any...

Const test1 As Single = numero + 500 Const test2 As Single = numero + 800 MsgBox (test1 = test2) It display "False" although test1 and test2 both are shown as "2,147484E+09" in Locals Window. How can I see the complete content of test1 and test2? (eg. in binary code)

Hi. I have a userform, with two textboxes, and a button. The button enters the values (text and numbers) from the textbox to cells. Example: Textbox1 and textbox 2. If i write 1A in txbox 1 and 2A in txbox 2, then it enters that value in A2, and B2, then if i type new values, it goes in A3 and...

Hi, I currently have the script below to copy a wksheet to a New Workbook. R9096 is 1 of 35 reports and they have their own worksheet. I would like the user to have an option of selecting the reports they want to extract. Is this possible to do within a macro? Maybe a drop menu showing the...

My understanding of a variable's lifetime is that if it is declared at the module level, it retains its vaue, even after the sub has finished running. So in my following code, after first running Test1 to the end, if I run Test2, the messagebox shows the value of 10, as expected. Dim a As...

I was trying to randomly select items from an array, I don't think the below is possible so I'm going to break it out into cells. I have an array in A1, everything below is submitted with ctrl shift enter just in case. A1={"test1","test2","test3"} I want to be able to...

Hi, I am stuck on one point. I want to compare directly 2 VBA tables, I even do not know if possible: here code: test1 = sheet(1).range("B2:f2") test2 = sheet(2).range("C10:G10") I want to compare test1 and and test2. Can I do directly : if test1 = test2 then do something endif It seems it...

Hi I am trying to search a data within a table and return the header of the corresponding column. For example, <tbody> A B 1 Test1 Test2 2 12 17 3 13 18 4 14 19 5 15 20 6 7 18 B </tbody> If cell A7 = 18, then cell B7 = Test2 If cell A7 = 15...

Hey everyone, I was working on a project in excel where I have 9 columns of dates. They each column represent a milestone in a project (it's kind of a scheduler). I want to make a pivot table that makes it so I can see all the milestone dates. Currently this is impossible as they are in 9...

Hi I am using iferror() to get rid of average() function error msg when cells test1,2,3 are 0 or empty. So I did below. But I have a problem with If() (cell E2 has the average function). So if() in this case returns "pass" when test1,2,3 are 0. How to fix that? I mean can I print nothing as a...

Please help me <tbody> Damage ID Status Tab product time Cable time Delay (Damage ID) Cable time Delay (Damage ID) Delayed firm1 and firm2 time sum 80640 Cable Cable - new application dsl 36939:51:15 ??(One and the same: ID 80640 ) ?? 80640 Cable Delayed firm2 dsl 3991:19:15 ??(One and...

Hi All, I was wondering if there's a method to achieve the following. I work with a large number of externally provided fixed format workbooks. From all those workbooks I need a number of values which are in the same exact cells. See table below for an example of what I would like to achieve...

Good Morning, I'm looking for some assistance on a formula that will provide a count of unique instances in column B, when Column A is "No". I have success with (=SUMPRODUCT(1/COUNTIF($B$2:$B$9,$B$2:$B$9))), but all is lost when I try to change the COUNTIF to a COUNTIFS to encompass the...

Hi, Could you help with the formula for below Sheet 1 has suppose process Name A Test B Test1 C. Test2 Sheet 2 has Row1 process. Test. Test1 Test 2 A. 10. 20. 30 B...

Hi, I am facing issue while copying a column with blank cells in between filled cells. Here I recorded one macro which looks like this - Sub Test1() ' ' Test1 Macro 'Range("H1").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Range("M1").Select...

Hi, Is it possible for vlookup to return a cell greater than x but below y. two conditions. name (a1) and number (b1) Quick and dirty example below: vlookup(a1 and b1) return test1 <tbody> Sally 750 Bill Sally Dave 0 500 501 1000 test1 1001 1500...

I'm trying to create a workbook where a range consisting of 4 columns is selected, and a macro is run to to duplicate information in the second column according to the amount of information input into the other three columns. For example: <tbody> I want to turn something like...