test1

  1. Joesif

    Macro Help

    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...
  2. M

    Military time to regular time in different timezone

    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...
  3. Z

    Find XML node with vba userform

    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...
  4. B

    VBA Run-Time Error 438

    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...
  5. 6

    how to see the complete content of floating point numbers

    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)
  6. W

    Finding duplicated values in a cell with userform

    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...
  7. S

    Option within Macro select wsheets when copying to a new Wbook

    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...
  8. T

    Scope and lifetime of variables

    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...
  9. J

    Is it possible to Index a single cell array?

    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...
  10. M

    Compare two tables in VBA

    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...
  11. W

    Search data within table and return the column header

    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...
  12. J

    Taking 9 columns and making them vertical with other data

    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...
  13. L

    iferror()

    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...
  14. X

    sum

    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...
  15. M

    Dynamic reference to external workbooks in formula's

    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...
  16. M

    Unique count based on two criteria

    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...
  17. A

    Excel formula to compare columns with one column and row

    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...
  18. T

    VBA code to Copy column having blank cells in between Filled cells

    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...
  19. A

    If vlookup between two numbers

    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...
  20. D

    VBA-issues refrencing multiple range selections

    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...

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