found

  1. Z

    Help with a vba finding Function with issues

    Hello all, I'm trying to draft my own search function from a list found on one sheet. Function Contactr(target As Long) Set NOCws = ThisWorkbook.Worksheets("NOC") Set Conws = ThisWorkbook.Worksheets("Contact") lrow = Conws.Cells(Rows.Count, 3).End(xlUp).Row With Conws.Range("C5:C" &...
  2. gravanoc

    Is Selenium worth using?

    I spent a while trying to find out if there is an up-to-date version of the Selenium add-in, but haven't had much luck. It's an add-in that allows VBA to manipulate Chrome and Firefox as object models just like IE. This would be tremendously useful since IE is not able to navigate some...
  3. E

    Highlight words that have the same first two characters from two different cells

    How do I get excel to Highlight words that have the same first two characters from two different cells For example <tbody> A B 1 abfgr( this should highlighted since the same first two letters is found in cell B2) gh( this should highlighted since the same first two letters is found in cell...
  4. H

    macro to color items

    I have a macro which I have written to color A3:E3 with an accent style as well as where "Grand total" is found + 4 columns after Grand total is found The macro colors A3:E3 + E4 and does not color the rows where"Grand Total is found" + 4 columns after this for eg if Grand Total is in A64...
  5. immyjimmy

    Excel related, but not formulas or visual basic

    Hello... My work computer was recently upgraded and Excel now is hiding workbooks that I have open. I'm not hiding them, but until I found out about how to find hidden files, thought I was losing them. When I Googled "excel hides my workbook and I can't get it to stop", I found all sorts of...
  6. J

    Find partial string and then paste whole cell contents as an offset to another 'searched for' string

    I know that's title gore and I am sorry - that was my best effort! I need some VBA to help search for the word "Qualification" which will always be found ONCE in column A. Once found I need to copy the whole cell contents and paste it to the left of cell that contains the string "Name" (which...
  7. N

    Copying all Cells between Locations from Array

    I've imported an XML file into excel but it did not input that neatly and am now trying to extract the data out that I need. There are a number of department in the data with performance ratings. The number of departments is not always the same and the number of performance ratings is never the...
  8. D

    Importing Userforms

    The List Search add-in developed by Excel Campus is fabulous. Exactly what I needed. A number of other people are going to be using my workbook, and doing so on a number of different computers. Having everyone download and install the List Search add-in may not be practicable. I would therefore...
  9. D

    Adding Sheet and row address to MsgBox

    Well this is probably an easy answer but all I have tried gives me an error. This is the part that works as intended but I cannot derive the sheet name where found and the row it was found on that sheet. ElseIf rng Is Nothing Then Set ra =...
  10. E

    VBA to rename sheets based on cell value (with duplicates)

    Hi All, I've seen many posts with questions similar to my own but cant find one to solve my problem. In fact I have a few issues which I will detail here, any solutions to any of them will be extremely helpful. I have a report I export into excel, the report is multiple sheets each sheet...
  11. S

    Follow hyperlink function to hidden sheet

    Hi After browsing a bit on the topic I cant find any information if it is possible to follow hyperlinks to hidden sheets through the hyperlink function? I have found several ways with the normal link option but the name in my function is a value found by formulas it would require some extra...
  12. H

    Find Text then Copy and Paste

    Hi - I have data on Sheet1 A:Z. I want to search column A for text that is entered on Sheet2A5. Once that value is found on Sheet1, i want to copy from where its found in A to Z and down 6 rows. So if Sheet2A5 is found in sheet1A30 Sheet1A30:Z36 is copied and pasted to sheet2AB5. thanks!
  13. C

    Resume Next not Resuming

    Hi all, I have a macro that loops through a list of items, locates them on another sheet via a FIND method and collects some data pertaining to the found item. It works well, except that it stops when the item is not found. To handle this, I used an On Error Resume Next statement, so that the...
  14. J

    Create a Visio drawing from Excel

    I am looking for some sample code that will create a visio document from info in an excel sheet. I had done a couple of versions myself about 8-10 years ago but have been out of the game and lost my toolbox of code modules. There used to be a lot of examples out on the web but I don't see very...
  15. DataBlake

    Character Limit As Conditions

    Hello All, I'm looking for efficiency so a formula or VBA will work for this. I'm trying to find the best way to create a title that is as close to 80 characters as possible So the title is broken down like this Quantity - Color1 - Brand1 - Size1 - Style1 - Pattern1 - Size2 - Brand2 -...
  16. D

    VBA Msgbox to show duplicate entries in column

    hello all, i have been searching quite some time for this but have not found a VBA script that meets my needs. hoping you can help. I am looking to have a button at the top of my sheet when clicked, will search col. F in sheet8 for any duplicates. If duplicate entries are found it will display...
  17. E

    Lookup issue returning odd results

    Hi all, I have the following LOOKUP formula =IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($FL$3:$FL$10002=C3)*($FM$3:$FM$10002=I3)),$FO$3:$FO$10002),"Backorder")) This seems to work most of the time but for some reason results "" when there is nothing found in FO3:FO10002 Sometimes...
  18. F

    Finding Text in One Column and Deleting Row if Certain Text Found in Next Column

    Hello, I'm trying to code a macro to search for specific text in one column, then looking in the same row in the next column for specific text, and if found, deleting that entire row. For example, in Column G I want to search for FILL CP VHCL. Say this is found in G7 and G8. If the text in...
  19. P

    Runtime error '1004' application-defined or object-defined error

    What I would like the code below to do is find the value of the variable "str" then place the value of the textbox called "TxtBxBlkBlnd" inside Range(found.row, "Column Letter Here") but I keep getting that same Runtime error '1004'. Would someone mind explaining what this error means in simple...
  20. P

    Need help

    I have code that High Lights Duplicates in a Workbook. Out of the 12 sheets only 7, I want to find dup's. All 7 are formatted as Table's and are identical. It also high lights the tab when one is found. It works perfect but I cant figure out how to exclude 4 of the sheets. Columns are A - T and...

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