Active cell to specific cell

[ipbr21054]

Hi,
I wish to replace the code part where it shows Active cell with a specific cell, being Z40

MonthsIncome.MyIncome.Value = ActiveCell.Value

With active cell in use I’ve noticed that when say B50 is selected then that’s the active cell.
Either way I need Z40 to be the cell in question whether Z40 or B50 is selected.

Thanks.

 

[sheetspread]

MonthsIncome.MyIncome.Value = Range("Z40").Value

 

[ipbr21054]

Great,works a treat.

Thanks for your time