range select

  1. I

    VBA With / select statement not working

    Hi all, I have a VBA script that combines data from two different workbooks. This includes a need to change the format of some data, but this part of the script isn't working as expected: Set extwbk = Workbooks.Open(myLSSource) Set x = extwbk.Worksheets("Sheet1").Range("$A$2:$O$10000") Set y =...
  2. 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...
  3. 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.
  4. 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...
  5. 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
  6. 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...
  7. 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" &...
  8. 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...
  9. 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...

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