This was exactly the code ive been looking for and ive used it to define
where to paste some copied data into,

I would now like to manipulate it further so that I could copy the
formula from row 2 all the way down to the last row, ive been trying
something along the lines of

Range("F2").Select
Selection.Copy

Dim rng2 As Range
Set rng2 = Cells(Rows.Count, "A").End(xlUp)(1, 6)
rng2.Select

Range("F2:rng2").Select
ActiveSheet.Paste

It is not quite working,
1st question - can i use the bit in red?
2nd question - will this make all cells between F2 and rng2 active so
values can be pasted into them?


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=520077