Hi there,

I am currently pulling my hair out over what I thought was a simple piece of code.

Basically I want to access a cell value using the range function. However, I need to access the row and columbn seperately as I am wanting to use activecell.row on the row and then just hardcode in the column.

The line Im using is below but doesnt seem to be giving me bak the answer I want, any idea's? 

MsgBox (wsCD.Range((Cells(ActiveCell.Row, 5))).Value)
wsCD is my sheet I'm working on.

Cheers,

Jag