Posts by Foxxy1

  • Delete all Falses

    I basically need to delete :rambo: all rows (the whole row), that contain the value false in columns "D:H". It needs to have a false in ALL columns, not just 1. Thank you very much for all your help. :thanx: :kitty:

  • Autofilling

    Thanks, but...


    I'm trying to get it to work and I kind'a get what's happening, but I'm trying to get a formula to copy downward and I'm just not grasping the concept. This is the formula I'm working with:


    Code
    Range("D1").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],C[5]:C[10],2,FALSE)"


    Please Help. Thanks again

  • Autofilling

    Is there a way to fill column "B" down to the very last cell located in column "A" when column a varies each time? Thanks for any help.

  • making a list of error values

    What I'm trying to get to work is for a macro to go through several columns (A,B,E,F, & G) and find error values associated values in 1 colmumn, with values being "N1-1, N1-2, N1-3, N2-1, N2-2, etc." that will vary, sometimes going from N1-1 through N1-10 or N1-1 through N1-17 etc. These values can reach N1 through N30 or more, and the list is in no particular order. I then need to compile a list of all the values (i.e. N1-1) with a cell containing an error value in any of the colums (A,B,E,F, or G) on a seperate sheet. If more info is need I would be happy to oblige. Thank you.


    31|RSS-24MCW-FR|Start|N1-1|10|10|#N/A|#N/A
    15|RSS-24MCW-FW|N1-1|N1-2|15|25|0.041|#N/A
    |ET70WP-2475W-FR|N1-2|N1-3|14|39|#N/A|#N/A
    15|ET90-24MCC-FW|N1-3|N1-4|30|69|0.045|0.145
    |AH-24-R|N1-4|N1-5|100|169|0.050|0.100
    |CH90-24-W|N1-5|N1-6|24|193|0.020|0.050
    |MB-G6-24-R|N1-6|N1-7|62|255|0.030|0.030


    is my e-mail address if more is needed (Edit: removed by Admin - see user profile)

  • Finding associated error values, then displaying them in a list

    What I'm trying to get to work is for a macro to go through several columns (A,B,E,F, & G) and find error values associated values in 1 colmumn, with values being "N1-1, N1-2, N1-3, N2-1, N2-2, etc." that will vary, sometimes going from N1-1 through N1-10 or N1-1 through N1-17 etc. These values can reach N1 through N30 or more, and the list is in no particular order. I then need to compile a list of all the values (i.e. N1-1) with a cell containing an error value in any of the colums (A,B,E,F, or G) on a seperate sheet. If more info is need I would be happy to oblige. Thank you.

  • Deleting Rows of Data with the Value #N/A

    Actually I was thinking about something else and if I can get that to work then it won't matter whether it's 1 or all. What I'm trying to get to work is for a macro to go through several columns and find error values associated values like "N1-1, N1-2, N1-3, N2-1, N2-2, etc." that will vary, sometimes going from N1-1 through N1-10 or N1-1 through N1-17 etc. These values can reach N1 through N30 or more, and the list is in no particular order. If more info is need I would be happy to oblige. Thank you again Tom.

  • Deleting Rows of Data with the Value #N/A

    I have a list of generally 17 rows (sometimes a little more) within my worksheet several times over. I'm curious if there is a way to setup a macro that will realize that if the value in the 1,2,5,6, and 7 columns are #N/A, that the row they are contained in need to be deleted. Thank you in advance for any help you can give.

  • Compiling lists, without the first "title" cell, into 1 column

    I also have a zero value after the last cell with a value that I dont want to appear. If it is easier to start out with 3 columns with a list of values that will be of an unknown length and carry the same value multiple times and create 1 list in a column with all the values entered one time only, it would actually be better for me. Thanks

  • Compiling lists, without the first "title" cell, into 1 column

    I'm trying to compile 3 seperate lists in 3 seperate columns, into 1 column. The length's of the list's will always vary and I cannot, therefore, make a macro to copy and paste into the same column because of this, at least to my knowledge. Is there a way to ignore the first cell in each column, also. If there is a way to do this, any help you can give I would appreaciate.

  • Compiling Mutiple Lists into 1 column

    I'm trying to compile 3 seperate lists in 3 seperate columns, into 1 column. The length's of the list's will always vary and I cannot, therefore, make a macro to copy and paste into the same column because of this, at least to my knowledge. If there is a way to do this, any help you can give I would appreaciate. If you need more detail, please let me know. Thank you.