Challenge with a bit of VBA code to select a particular field

[nicklbailey]

Dear Everyone,

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>

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

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

 

[mumps]

Hi Nick. Your explanation is a little hard to follow. When you say

I want to select all of the rows in the last column (which is blank)

do you want to copy the entire row or just the cell? Also, I'm not sure what you mean by

The column number of column32 and column33 are both variable

Could you please be more specific using column letters rather than column numbers and perhaps an example of what you want the data to look like after the macro is run?