Setting the address of an output cell

[poiu]

Hello,

I'm trying to set the address of my output cell, which is 4 columns to the left of a cell that I've identified.

However when I try to set the address of the output cell using the line of code in bold below I get the error message "object required".

adjusted_date_cell.Row = 13
adjusted_date_cell.Column = 8
 
[B]output_cell.Address = Cells(adjusted_date_cell.Row, _
adjusted_date_cell.Column - 4).Address[/B]

Thanks,

Poiu

 

[Joe4]

How have you defined adjusted_date_cell?
As a range variable or a numeric variable?

What are you trying to do by setting this address?
Are you trying to write something back to the worksheet?

 

[Jonmo1]

The address property of a range is Static (Read Only)

Try chaning that actual range reference, not it's address..

Set output_cell = adjusted_date_cell.Offset(0,-4)

 

[stubarny]

Thanks guys, much appreciated.