nicklbailey
New Member
- Joined
- Apr 10, 2013
- Messages
- 3
Dear Everyone,
I am having trouble with a bit of VBA code, here is what I want to do:
<tbody>
</tbody>I want to select all of the rows in the last column (which is blank) going down as far as the last row in the previous column that has data. In this example that would be the three cells with Xs below
<tbody>
</tbody>
The column number of column32 and column33 are both variable as is the number of values in each, but column 3 is always one after column 2. I want the macro to run when the second row of Column3 is selected. This is my code
ActiveSheet.Range(Activecell & ActiveSheet.Range(ActiveCell.Offset(0, -1)).End(xlDown).Offset(0, 1).Address).Select
It consistently gives an error, and I am not sure why
Help would be appreciated
I am having trouble with a bit of VBA code, here is what I want to do:
Column1 | Column2 | Column3 |
Value | Value | |
Value | Value | |
Value | Value | |
<tbody>
</tbody>
Column1 | Column2 | Column3 |
Value | Value | X |
Value | Value | X |
Value | Value | X |
<tbody>
</tbody>
The column number of column32 and column33 are both variable as is the number of values in each, but column 3 is always one after column 2. I want the macro to run when the second row of Column3 is selected. This is my code
ActiveSheet.Range(Activecell & ActiveSheet.Range(ActiveCell.Offset(0, -1)).End(xlDown).Offset(0, 1).Address).Select
It consistently gives an error, and I am not sure why
Help would be appreciated