range select

  1. D

    select range to the right and down

    Good afternoon everyone. I have a macros which goes to a certain cell, and selects all the active cells to the right and below in the certain table. Range(ActiveCell, Cells(ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column)).Select the goal is that it selects everything in that...
  2. J

    VBA Select active rows

    I want to select all the active rows in my spreadsheet starting with row 4. Columns A-I are populated. This is what i have so far, but it's wrong: ActiveSheet.Range ("A4:I" & Range("A" & Rows.Count).End(xlUp).Select) Thanks.
  3. G

    VBA to select a range from active cell to a border

    Hi, I am looking for VBA code that can select a range from the currently active cell down to the next border. There are random blank cells in the column, which prevents me from being able to 'select all' to the next blank cell. There are multiple tables, which vary in size and are arranged...
  4. F

    Select column using cells

    Hi, I have loop, where I want to select column starting from AF till to AQ: AF2:AF100 then AG2:AG100 then AH2:AH100 etc.... .... For i=32 to 43 last_rowx = ws.Cells(Rows.Count, "A").End(xlUp).Row ws.cells(i,2)...??? next i
  5. F

    Problem with Range selection macro

    Hello, I am running the following piece of code in my macro. Sub SelectData1() Set mySelection = Range(ActiveCell, ActiveCell.End(xlDown)) mySelection.Select End Sub When I run the above code as a stand alone macro it always works as it should; ie. it selects all the data in the column...
  6. B

    Find Row Below

    I want to go to the cell below a range of data. My macro keeps returning the last row + next row for the range. I only want the row below the range not to include the last row itself. How can I change the following?: LastRow = Range("L" & Rows.Count).End(xlUp).Row vRange = "L" &...
  7. D

    VBA Inserting Formulas in to Cells

    Afternoon, I have some code...which is very long winded but it has two issues. Firstly when it copies the formula in to the cell it references the target cell with speech marks for example 'B12' meaning that teh forumula lookup doesnt work. Second problem, as you can imagine as the...
  8. D

    Macro Beginner - Help Selecting / Naming Changing Range

    I promised I've tried seaching before asking...I'm trying to select a range of data so I can assign it a range name. I often import data where the number of columns and rows change and not every cell has data present. I use the command "Range(Selection...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...