Search:

Type: Posts; User: danielpalfrey; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Unhide cells to copy them then hide them again

    I will test when I get home. The reason for in hiding is because I am using instr to find a currency symbol. Instr does not find in hidden cells
  2. Unhide cells to copy them then hide them again

    Hi guys. As the title says. I am looking to unhide columns so that I can search them for a value. The cells matching the criteria are then copied and pasted onto sheet two. I have the copy and past...
  3. Re: reference externel workbook cells based on value

    I will double check exactly what the manager wants. There are less than 100 suppliers. The cells I am interested in contain a symbol. All the workbooks are located in different folder but all only...
  4. reference external workbook cells based on value

    Ok, I have been tasked with a new project at work and it is honestly out of my scope, I have told them I will look into it but wow, this is hard even if it is possible.

    We have multiple suppliers...
  5. Replies
    12
    Views
    487

    Re: Finding multiple cell addresses

    I have even been able to modify the code to clear my irrelevant rows, this was well written and easy to understand what was happening :)
  6. Replies
    12
    Views
    487

    Re: Finding multiple cell addresses

    Thanks for the code, I have it working perfectly now, had to make a few mods to get it to work on button click.


    Private Sub tst_Click()

    Dim Cancel As Boolean
    Dim Target As Range
    Dim Onecell...
  7. Replies
    12
    Views
    487

    Re: Finding multiple cell addresses

    I will test the code in a moment but no, my code looked incomplete.


    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

    hre = ActiveCell.Row + 1
    lst =...
  8. Replies
    12
    Views
    487

    Re: Finding multiple cell addresses

    Yes that is correct. I will double check the code as I copied and pasted from my phone and we all know that doesn't help.
  9. Replies
    12
    Views
    487

    Re: Finding multiple cell addresses

    Dim hre As StringDim WrdArray() As String
    Dim FindText As String
    Dim Onecell As Range
    Dim hr As Label
    hre = ActiveCell.Row + 1
    lst = "one/two/three/four/five/six/seven/eight/nine/ten"

    If...
  10. Replies
    12
    Views
    487

    Finding multiple cell addresses

    Ok guys, I am going to try and explain this clearly this time.
    I have a spread sheet, in column A there is a list of words. There is a button on the spread sheet, we will call the button tst.
    The...
  11. Replies
    5
    Views
    239

    Re: searching for cell location

    Ok, I got it working kind of earlier but it ended up looping around after finding the text which was annoying me. I have now come up with a fix which I know will be frowned on but it worked and I did...
  12. Replies
    5
    Views
    239

    Re: searching for cell location

    You are right, the code in the first post is code I have searched for and put together, not entirely understanding it. Double click event happens on column A Upon double click the code needs to look...
  13. Replies
    5
    Views
    239

    Re: searching for cell location

    Ok, so below is a clipping of the original code, this code worked for what I needed but never made it easy for what I wanted to do (in terms of adding suppliers to the list(sups))




    Dim sup1...
  14. Replies
    5
    Views
    239

    searching for cell location

    Ok, this is a little unusual, I need to find cells that contain one of multiple words.
    The plan is, double click a word in column A, upon clicking this word a list will be searched to find out if...
  15. Re: Clicking different cells to open files

    I will give this a try. But there might be an issue because I have a double click event set up to expand/unhide hidden rows below.
  16. Re: Clicking different cells to open files

    I had originally thought of using something like this

    Sub Open_Word_Document() 'Open an existing Word Document from Excel Dim objWord As Object Set objWord = CreateObject("Word.Application")...
  17. Clicking different cells to open files

    Hi guys. I have a spread sheet with multiple options on there. Previously I had used hyperlinks to link to word documents for the shipping labels but people are clicking by mistake a making a right...
Results 1 to 17 of 18