select cells

I need to have a macro that parses the data in the selected cells that contains the "=" value. Currently, I have two VBA codes. 1. The first (VBA code) works to find all cells with "=" value and is supposed to then parse all data, separated by spaces, in the selected cells into their own...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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)...

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 =...

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...

<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"...