select cells

  1. P

    Selecting Cells with Value and skipping the word False

    Hi Guys! It is my first time here on Mr.Excel forums and would want to seek for your help. What I would want to do is to: 1. Select the cells that has value 2. Skip selecting the entire row or cells that has "False" word in it, as there is an IF formula that returns false if it has no value...
  2. R

    Non adjacent cells selection

    Hi Simple question which I've struggled with.. I want to select non adjacent cells e.g. A1 and C1. I tried Range(Cells(1, 1), Cells(1, 3)).Select amongst other things but to no avail. Thanks
  3. S

    Select cells relevant to a page, call macro, go to cells of next page and so on.

    Hello Friends. I'm looking for a way/code to automatically select the cells in Column 2 that have the same page number associated with them in Column 1. Then I want to call a macro and then repeat the process. I have provided the link for the 15kb macro enabled excel file with which I need help...
  4. R

    Passively select cells in other worksheet

    I have written some code that runs about 400 lines of code in one worksheet, then 400 lines of code in another worksheet ("Calendar"), and finishes by returning to the first worksheet. When I run the code, it takes about a second to process. There is a flicker for about a quarter-second where...
  5. D

    Go to cell based on another cell

    Hi all, I have been having trouble trying to figure this out. Sheet1 L26 has a cell address which varies. I would like to go to this cell on Sheet2. e.g. if the value of Sheet1 L26 = A4, I would like to select cell A4 on Sheet2. I have attempted to use this code that I found online with...
  6. D

    Using Excel Macro to Create a Drop Down List and Hide Cells

    I am having trouble with a macro that is supposed to perform the following tasks: Prompt the user to input a cell where the drop down list is to be located Prompt the user for a range of data to use in the drop down list values Create drop down list Hide the rows in which the drop down list...
  7. R

    vba procedure to capture multiple cell values

    vba procedure to capture multiple cell values hi folks, ok, new to this forum, so if my presentation is lacking, please let me know so i can fix as appropriate. here's what i do now and what i'd like to do going forward: current process: 1. enter a stock ticker in cell B1 2. click a button...
  8. R

    Selecting Cells in column for Deletion

    Hi, I am trying to select a number of cells in a column that may not be sequential in order to delete these cells and move cells up 1. My goal would be much like the following manual example: Click on cell G4 Hold Ctrl key Click on cell G6 Right click Select delete Select Shift Cells Up I...
  9. A

    Macro to change dataset based cell selected

    I have one button at the top of my page that I would like to assign a Macro to but my little brain can't grasp how to do it. Please help...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> My goal is to find out how many hours per month a motor...
  10. O

    Select the cell below the last row in a table

    Hi Guys, I need a macro that will select the cell right below the A column in a table. Right after this I have a macro that puts a value into that cell, thereby increasing the size of the table automatically. I had a macro but its not working anymore, which means it wasn't very robust...
  11. R

    Selecting a variable bounded range

    Hi. I'm going bald on this one! I need to select a range bounded by the values in cells. I have a choice: I can select based on values CopyRow1, CopyCo1l to CopyRow2, CopyCol2 where I can calculate the second set as an offset of the first, which is variable - these being integers. ie...
  12. R

    Please Help Me Select Cells

    I've got a cheesy macro that goes row by row and sets conditional formatting to color the highest value in red and the lowest value in blue. It was made by recording and modifying. It works well but the user inputs are, well, n00bishly cumbersome. How can I change the macro to use the...
  13. J

    Visually select cells using VBA

    I would like to go to a particular cell in Excel once some VBA code has finished running. I have used Range("A123").Select (and tried .Activate) but the window (which has frozen panes) stays down at line 2,000 even though A123 is active. How do I get the window to physically display the...
  14. P

    Select Specific Row in Active Column

    Using Excel 2007 - this needs to also work in Excel 2003 I need to create a Macro for the following Copy Row 1 thru 4 of the column for the Active.Cell to Row 1 thru 4 of the column to the right of the Active.Cell (the active cell will be wherever the user left the cursor in the column used)...
  15. P

    Select a .find result VBA

    Thanks for looking, hope you can help! I'm trying to select a cell that is the result of a .find function so that i can then select its entire row and copy it onto a new sheet. My .find function is... On Error Resume Next With RecordsSheet Set phoneChk =...
  16. D

    runtime error 1004

    Hi I get runtime error 1004, Activate method of Range Class failed when I run the macro below using a double click from a sheet called "Europe". I have highlighted the code where the error occurs - any ideas anyone? Private Sub Workbook_SheetBeforedoubleclick(ByVal Tgt As Range, Cancel As...
  17. T

    Selecting 1 static cell and 1 variable cell and fill down

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 12"><meta name="Originator" content="Microsoft Word 12"><link rel="File-List"...

Watch MrExcel Video

This Week's Hot Topics

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
Top