tested

  1. D

    Converting specific columns to vertical one record

    I have similar to this table with many columns and thousand of rows (patients) - as you can see each patient have 6 tests(test1 to test6) with different 6 result. - all other columns have the same result. - I need to switch the results from vertical to horizontal so I the table can show one...
  2. D

    switching specific coulmns from vertical to horizantal to get one record !

    I have similar to this table with many columns and thousand of rows (patients) - as you can see each patient have 6 tests(test1 to test6) with different 6 result. - all other columns have the same result. - I need to switch the results from vertical to horizontal so I the table can show one...
  3. JenniferMurphy

    Does Stop in a sub-procedure always persist to the caller?

    If I write a general-purpose error handler that, among other things, executes a Stop statement under certain conditions, can I be assured that it will persist past the termination of the sub-function and allow me to continue stepping through the caller using F8? I have tested it and it seems...
  4. S

    [VBA] Condition to check if (merged) cell is in error

    Hello, I have the following code: If Not Intersect(Target, Range("C8:D8")) Is Nothing And Range("C8").Value <> "" And Not IsError(Range("C8").Value) Then The code runs when the cell is selected but I do not want it to run if the cell shows an error. I tested this when the cell showed #NAME...
  5. M

    why does VBA this statement ignore 0 values - it shouldnt

    Hi All Hoping you can help me understand why this is ignoring 0 values when it shouldnt - it is a number and ive tested it If c.Value <> "" And c.Value <> Empty And c.Value <> "Ok" And c.Value <> "Not Ok" Then 'do something Thank You
  6. B

    Multiple Search Fuctions

    <tbody> Employee Language Tested? 4256 English Y 4256 French N 4637 English Y 34256 Madarin N </tbody> So I have 2 spreadsheets, where i need to compare multiple values. Some of the values such as the employee number however its a different language. how do I...
  7. H

    issue getting criteria1 when two selected items

    hi, All ! I can get a single data when only one item is selected I can get an array of data when three or more items are selected I can not get an array if two (only and exactly two) items are selected tested with: <sheet>.autofilter.filters(1).criteria1...
  8. F

    Web scraping

    Hi guys. I have some problems with IE on win 7, 64bit. There are some sites that have lots of java and flash content. when I open them in IE these sites shows only a blank screen (both IE10 and IE11). I've tried to change security settings in IE to get it to display these sites but so far...

Some videos you may like

This Week's Hot Topics

Top