Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Adding a name to a list if it doesn't exist

    I have a spreadsheet that is used to generate quotes for clients.



    The worksheet (npss_quote_sheet) is used to generate 1 quote for one client at a time.
    There is a table (npss_quote) that...
  2. Re: VBA to see if a column contains a certain string

    Sorry about that, i forgot to include the code


    Sub cmdSend()
    Application.ScreenUpdating = False
    Application.EnableEvents = False
    Dim desWS As Worksheet, srcWS As Worksheet
    ...
  3. Re: VBA to see if a column contains a certain string

    Maybe I have accidentally changed something. Could you look at the cmdSend code to see if I have mistakenly added something. It is the code that is run that copies the row across to tblCosting....
  4. Re: VBA to see if a column contains a certain string

    White and light blue that appears to be the standard colour of a table.
  5. Re: VBA to see if a column contains a certain string

    Just noticed that is has appeared to have changed the colour of every cell in column F of the source workbook to be blue, where the rows around it are alternate colours. How can I make it the same as...
  6. Re: VBA to see if a column contains a certain string

    That seems to have worked, thank you so much Michael :)
  7. Re: VBA to see if a column contains a certain string

    Thanks for all this help Michael,

    I put that code in and no colours got changed. I ran it a second time and got the error subscript out of range with this line highlighted


    Range("F" &...
  8. Re: VBA to see if a column contains a certain string

    With all these tests, I have 4 rows in my source table with the first 3 rows (4-6) having Yir in column F and the forth row (7) has something else.
    If I change it to F1, the heading at the top of...
  9. Re: VBA to see if a column contains a certain string

    I just tried having one row already in the destination wb and then ran the copy procedure and the first row to be copied across was not coloured but additional rows were. Therefore, the first 2 rows...
  10. Re: VBA to see if a column contains a certain string

    Actually Michael, it is working but it won't colour the first row if, but will colour additional rows. When I first tested it, I only tried to copy 1 row, so I didn't realise that it was partially...
  11. Re: VBA to see if a column contains a certain string

    Just realised that I cannot have conditional formatting as that would require formatting the actual document that the rows will be copied to, but I need it to be formatted from the original document...
  12. Re: VBA to see if a column contains a certain string

    Thanks Michael,

    Did I put the code in the right spot as this is my code and it doesn't appear to change the colour?


    Sub cmdCopy()
    Dim wsDst As Worksheet, wsSrc As Worksheet, tblrow...
  13. Re: VBA to see if a column contains a certain string

    It starts in F4 and it was giving me an error but now it isn't. Anyway Michael, I need to go now so I will continue on Wednesday when I am back at work.

    Thanks.
  14. Re: VBA to see if a column contains a certain string

    Thanks for that Michael.

    It appears to only change the colour of the first row and if Yir is not in the first row, it could be anywhere, I get an error.
  15. Re: VBA to see if a column contains a certain string

    There could be multiple rows in tblCosting before they are copied across. There could be a row with Yir in column 6, a row with ang wes in column 6 then another row with Yir in it. Only first...
  16. Re: VBA to see if a column contains a certain string

    Thanks for that Michael, just got a few issues with it.

    I want the text colour to change, not the highlighting
    It appears to change the row colour the first time the procedure is run. If...
  17. Re: VBA to see if a column contains a certain string

    There could be up to 500 rows Michael.

    I think I want to go with the vba option. Just trying to work out where to incorporate it into my code. This is my procedure:


    Sub cmdCopy()
    Dim...
  18. Replies
    3
    Views
    79

    Re: Correct syntax for row colour

    Here is the entire procedure as I think I have it in the wrong place


    Sub cmdCopy()
    Dim wsDst As Worksheet, wsSrc As Worksheet, tblrow As ListRow
    Dim Combo As String, sht As...
  19. VBA to see if a column contains a certain string

    I need code to check if a cell in column F contains certain text. I then need to apply colour formatting to the entire row. Can someone help me please?
  20. Replies
    3
    Views
    79

    Re: Correct syntax for row colour

    I forgot to mention the start of the procedure has a few bits you need to know.


    Sub cmdCopy()
    Dim wsDst As Worksheet, wsSrc As Worksheet, tblrow As ListRow
    Dim Combo As String,...
  21. Replies
    3
    Views
    79

    Correct syntax for row colour

    I have some code that copies data to other sheets depending on various options that are selected. This is part of my code that is working:


    Select Case tblrow.Range.Cells(1,...
  22. Thread: Type mismatch

    by dpaton05
    Replies
    2
    Views
    66

    Type mismatch

    I have this code that is run once a command button is clicked:


    Sub cmdSend()
    Application.ScreenUpdating = False
    Application.EnableEvents = False
    Dim desWS As Worksheet, srcWS As...
  23. Re: Need names also sent to another workbook

    Can someone help me with this problem please?
  24. Replies
    1
    Views
    100

    Removing brackets

    Can someone help me with this function, I am trying to remove the RoundDown feature from the formula but it is not liking the brackets that I am removing. How should it look?

    The formula is
    ...
  25. Re: Need names also sent to another workbook

    I have decided that I will just use a table in the workbook, client_list. The table is called ChildYP. I need vba for these things:

    Copy the string in the merged cell G7:H7 in the worksheet...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4