Hello All,
Another problem I have is in automating the number of rows down wit
which I copy a range of cells.
At present in the macro I have this bit:
Range("T5:AC5").Select
Application.CutCopyMode = False
Selection.Copy
Range("T6:T1008").Select
ActiveSheet.Paste
now rather than '1008' I want the 1008 bit to be a number that appear
in cell T1 (the number is different from sheet to sheet).
How do I do that?
Regards,
Jaime
--
jaimetimbrel
-----------------------------------------------------------------------
jaimetimbrell's Profile:
http://www.excelforum.com/member.php...fo&userid=2616
View this thread:
http://www.excelforum.com/showthread.php?threadid=51160