select rows

Hi All, I could use some help with getting the VBA on the following. I have a large range of data, blanks, and multiple duplicate cell values. I need to find (select) matching cell or cells , and then select the rows of those found cells. Not highlighted, just select. My search value is in (...

I am new to VBA. I can't watch excel at all times. I need to get email notifications automatically from excel. I need VBA codes. If cell value = "Buy" in Column Index AR, then automatically send email select rows subject = Scrip Name in Column Index C space Buy space High Break amount in...

I have Part IDs in Column C and my userform has Listbox containing Part IDs. If I select Part ID in Listbox then whole row containing that PartID should be selected. My Listbox is multiselect. So if I select multiple IDs then it should select corresponding multiple rows

Dear Sir/Madam, I'm having a Simple yet difficult problem which I can't figure out. I'm still a self learner of macro. My doubt: I have a Table where 5 column and many rows are there. All row of Col-A have a CheckBox (I added it from Developer Tab). Col-B, Col-C, Col-D and Col-E has value...

I'm working in a massive excel file and would like to add a conditional formatting rule to only rows "3n+1", Selecting them individually would take me hours. Thanks

Hello, If I want to select rows 5 to 10, inclusive, I can use this statement: Rows("5:10").Select However, to make this more dynamic, I have stored the start row in A1 and the end row in A2. What would the select statement look like, if I wanted it to use A1 and A2? Also, do A1 and A2 have...