Got a "Mid" problem

[NickMinUK]

Hi. I am trying to copy a value to a ref contained within another cell.
BF3 is where the formula is to copy
BJ1 contains the cell ref of "H6"
BI10 is the next cell to select

I think the problem is activecell = Mid(BJ1,1,5) which is the cell to which i want to paste the value. BJ1 contains the ref in text format of "H6" I am therefore trying to copy the value in BF3 to H6

Any idea what I am doing wrong?? Thanks in anticipation

Please Login or Register  to view this content.

[sweep]

You dont need to copy and paste.

Please Login or Register  to view this content.

[NickMinUK]

Fantastic and so simple. Thanks very much Sweep.

If I wanted to copy a furmula to H6, would i change all the "value" to ""formula"? Also if I wanted to copy to a cell one to the right of that contained within BJ1 ie I6 instead of H6, would I use the offset function, and if so, how would this be incorporated. Thanks again Sweep.

[sweep]

If I wanted to copy a furmula to H6, would i change all the "value" to ""formula"? Yes you would.


Also if I wanted to copy to a cell one to the right of that contained within BJ1 ie I6 instead of H6, would I use the offset function, and if so, how would this be incorporated?

Please Login or Register  to view this content.

[NickMinUK]

Thanks Sweep. Works a treat. Much appreciated. Nick