Cells function within a range

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?

Please Login or Register  to view this content.

wsCD is my sheet I'm working on.

Cheers,

Jag

Thanks for the reply, but it still doesnt seem to work for the purposes I need it.

Howcome when I use it within the following method, it doesnt return a value when I call msgbox?

Please Login or Register  to view this content.

Cheers,

Jag