Hey,
So I know how to select last rows and last columns seperatly but I cant figure out for the life of me how to combine the two. I am trying to first find the last column and then use the & Rows.Count).End(xlUP)) to find the last row aswell and exlude the header aswell if possible.
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 =...
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...
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.
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...
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
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...
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" &...
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...
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...
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.