select a range

I want to make a macro/VBA script that will search a single column for separators (dashes), select the rows between the dashes and transpose that data into another worksheet. There are several hundred "records" laid out this way. Ideally, I'd like the macro to find/select the next range and...

I am creating a macro and I filter out data then copy and paste it to another sheet for a report. The report has a different amount of results from month to month. How do I tell the macro to select all the results no matter how many there are? Select all doesn't work because there are multiple...

Hello, I'm looking for a macro that will select the rows in column U that have a corresponding value in column A. Column A has contigous cells with values whereas some of the cells in column U are blank and some have values. Thanks

I made a simple macro to move a row up one row (cut, selection Insert). I wanted to leave the active cell in the same col as at the start, so I save the start col# in intStartCol, getting it from ActiveCell.column. This is One Based At the end when I set the active cell back to the original...

I have a Range of Cells that I would like to transfer to PowerPoint using VBA Macro. The problem is that some of the cells are emty at times and I want to leave them out of the final range that is moved to PPT. I'm thinking that I have to select the largest possible range and then do some...

Hi there, I am using the following macro to have the letter u appear when the user clicks on cells in columns 5,6,7 and 8. This works line by line. I only want it to work when the line corresponds to a specific type of item, specified by the letter "S" in another column. Te macro works well...

Dear Experts, I am converting a xls workbook into a tab delimited text file, but instead of copying the entire workbook, I want to copy the first two columns of the workbook except for the header row. This is my code which is copying the entire workbook - Private Sub SaveAsTabDelimited(ByVal...

Is there a way to select a range between two cells with a defined name? For example, i have a two named cells (notes1 and notes2) that are not always in the same place (columns are added between the two, but between those ranges i need to select everything (not including the two named ranges).

Hello all, Merry Christmas and Happy New years! I am having an issue with VBA Scripting. This is what I've done: Sub Create_Dynamic_Forecast() ' ' Create_Dynamic_Forecast Application.ScreenUpdating = True 'ActiveWorkbook.Save Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = "Dynamic...

Hi All, I am developing a macro which select certain rows from table and highlight them based on the result. (Green for Okay and Red for Wrong). The criteria is if lets say "A1" has word "Happy" and "A2" has word "Happy go lucky" then after running macro, "A1" and "A2" gets highlighted by...

Hi, Im new to VBA and have come into a few instances where I have tried, unsuccessfully, to create a macro that will select every other row and then copy that selection. What I have been settling for is holding control and selecting whatever rows I need to copy but I am curious to know if it is...

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

Hi, I want to select cells when the range is under a certain number(<=0) and return value from other cells. My problem is more how to use the proper syntax. exemple: If Range("J2:J44") >=0 'Then ActiveCell = Select 'and return value in cell ("B2, C2") for each row.

Hello, here's the thing. I want to select a range of values but this ranges are not continuous. I tried =OFFSET(I21;;;;2)&OFFSET(I21;;5;;3) I would need this to select I21,I22,I26,I27,I28 I'm trying to define a Name Range with this, but as I test it, it won't be highlighted as a range. I...

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

Hi all, I need to select a range (on a different worksheet than the active one) based on input so I created this code: Where RLocatie is the row number. But I get runtime error 1004 on the second line of code. For some reason Excel can't select the range? Does anyone know what might be...

I have a simple macro I need some help with. I want to spin through a row range of cells (O2,X2) on a specific page. As I spin through, I want to check a specific cell in that range (S2) and see if that cell is either NULL or has a zero (0). If either is correct (NULL or 0) then delete the...

Just wondering, Do you guys every get tired of helping out people here? I surely hope not. Because I have another question for you. Thanks again! Right now I have found all my answers through search and / or asking directly in this forum. This is so much better than the office help file, or...